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