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.
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
