$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