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
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 ?
select * from table where data like %keywords%;
You can break up the search terms into words and do
$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