Re: searching multiple fields

Sounds like you want to use full text indexing. Create one full text index spanning name, area, organisation. Then search on all three fields at once. SELECT * FROM sheet1 MATCH(name,area,organisation) AGAINST('textstring* otherstring* etc*). The * means use LIKE searching. There are a bunch of other options you can use and also limitations. Read the manual for all the details. On Jul 14, 2005, at 4:37 AM, Ross wrote:

Is there a way to use like to search various fields at one time. For example I want the search field to search by name or area or organisation. If the (minimum)three letter string matches any of these I want the record to show. $search_field is my textbox $query = "SELECT * FROM sheet1 WHERE 'name' LIKE '$search_field%'"; but really I want it to do the folowing. $query = "SELECT * FROM sheet1 WHERE 'name' or 'area or 'organisation LIKE '$search_field%'"; Cheers, R. --PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php