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.

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to