Re: searchengine in php
| From: | Mark Maggelet | Date: | Sun, 29 Oct 2000 09:00:06 +0000 |
| Subject: | Re: searchengine in php | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-22533@lists.php.net to get a copy of this message | ||
On Sat, 28 Oct 2000 22:51:52 -0700, Joe Stump (joe@earth.care2.com)
wrote:
>> or you could just drop all your data into a MySQL table with a
>> FULLTEXT index on the keyword field and all this gets taken care
>>of
>> for you. this is definitely an easier way to go.
>>
>
>What and do a LIKE "%$search%"?!? That will scale to what 1000
>records?
nope. it looks more like this:
SELECT * FROM t WHERE MATCH (a,b) AGAINST ('MySQL');
check out the docs:
http://www.mysql.com/documentation/mysql/commented/manual.php?section=
MySQL_full-text_search
it scales very well.
- Mark