|
|
Posted by "yanghshiqi" on 10/31/00 11:21
Yes, hope you are using the MyISAM, full-text index is much better than
'LIKE'.
If you use the way like 'name like '$name%' or org like '$name'', it will
cost lots of your time...
Best regards,
Shiqi Yang
-----Original Message-----
From: Amir Mohammad Saied [mailto:amirmohammadsaied@yahoo.com]
Sent: Friday, July 15, 2005 1:51 AM
To: php-general@lists.php.net
Subject: Re: [PHP] searching multiple fields
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
Navigation:
[Reply to this message]
|