$keywords = str_replace(' ','%',$keywords);
select * from table where data like "%keywords%";-----Original Message----- From: Hadi [mailto:[EMAIL PROTECTED] Sent: 12 December 2003 13:21 To: [EMAIL PROTECTED] Subject: [PHP-DB] anyone trickier than 'LIKE' ? Hi all, I have this data (eg.) "..........big fat buddy......." on the database . If a person enter "big buddy" in the search form , the ".......big fat buddy........." data will not be found . Any suggestion ? Thanks in advance. select * from table where data like "%keywords%"; -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
