Re: Search tutroial
| From: | Dan Swensen | Date: | Wed, 24 Apr 2002 05:22:47 +0000 |
| Subject: | Re: Search tutroial | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-18778@lists.php.net to get a copy of this message | ||
Getting a search function running perplexed me, too, until I looked at the
MySQL docs. With the Full-Text Search function I got a search function
working in minutes.
http://www.mysql.com/doc/F/u/Fulltext_Search.html
Watch out for the weird bug that ignores duplicate rows, though. It can make
for zero returns in small databases for no logical reason. That drove me nuts
until I figured out why it was happening. (It's mentioned at the bottom of
the docs.)
> Hi all,
>
> Would someone kindly point me to a tutorial on designing a search
> script for mysql db. I have tried to build one but can't get
> anywhere with it.
>
> Thanks
> Jennifer
>
> --
> The sleeper has awaken
>
> ---
> Outgoing mail is certified Virus Free.
> Checked by AVG anti-virus system (http://www.grisoft.com).
> Version: 6.0.351 / Virus Database: 197 - Release Date: 4/19/2002
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php