Title: custom database search
Last modified: August 19, 2016

---

# custom database search

 *  [nic1190](https://wordpress.org/support/users/nic1190/)
 * (@nic1190)
 * [18 years ago](https://wordpress.org/support/topic/custom-database-search/)
 * I am wordpressafying a site which currently has a “search for a photographer”
   function, this allows users to search for a photographer by “speciality” “name”
   and “location” maintained by a mySQL DB. What I want to do is set up a custom
   search based on the information gathered from the wordpress users information
   which would mean extending those fields to include location and speciallity.
 * I’ve search high and low for anyone who has done something similar but have yet
   to find any documentation, if any one could point me in the right direction, 
   or even let me know if it could be done. I’m guessing it’s way over my head coding
   wise so I may pay somoene to do it but need to know where to start.
 * I could integrate the old DB and search but that then means maintaining two DB
   with the same information.

Viewing 1 replies (of 1 total)

 *  [gspx](https://wordpress.org/support/users/gspx/)
 * (@gspx)
 * [17 years, 11 months ago](https://wordpress.org/support/topic/custom-database-search/#post-788757)
 * there is a plugin called wp-folksonomy that might be able to help you tag images
   to their photographers, otherwise if each photographer has his/her own username,
   you could make a search that does something like this
 * `SELECT * FROM users WHERE NAME="name"`
    that gives you the row with their ID
 * Then you can search teh posts db with their ID number.
    It’s a heavy query though,
   may well not be the best way.

Viewing 1 replies (of 1 total)

The topic ‘custom database search’ is closed to new replies.

## Tags

 * [database](https://wordpress.org/support/topic-tag/database/)

 * In: [Developing with WordPress](https://wordpress.org/support/forum/wp-advanced/)
 * 1 reply
 * 2 participants
 * Last reply from: [gspx](https://wordpress.org/support/users/gspx/)
 * Last activity: [17 years, 11 months ago](https://wordpress.org/support/topic/custom-database-search/#post-788757)
 * Status: not resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics