Re: Searching a mySQL DB
| From: | Richard Archer | Date: | Mon, 15 Apr 2002 21:48:06 +0000 |
| Subject: | Re: Searching a mySQL DB | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-93097@lists.php.net to get a copy of this message | ||
At 4:06 AM -0700 15/4/02, Thomas Edison Jr. wrote:
>I have a table with a column vProName, which
>let's say, contains a record "Basket Ball Game".
>Now what i want is that if someone searches for "Game"
>or "Ball", even then this record should appear.
Either "select * from ThatTable where vProName like '%Game%'"
or for better performance and result ranking:
http://www.mysql.com/documentation/mysql/bychapter/manual_Reference.html#Fulltext_Search
...R.