Re: searching multiple fields
| From: | Amir Mohammad Saied | Date: | Thu, 14 Jul 2005 17:51:29 +0000 |
| Subject: | Re: searching multiple fields | ||
| References: | 1 2 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-218706@lists.php.net to get a copy of this message | ||
Brent Baisley wrote:
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: Just to remember!this method works just with MyISAM table types.