RE: [PHP-DB] anyone trickier than 'LIKE' ?
| From: | N dot A dot Morgan at bton dot ac dot uk | Date: | Fri, 12 Dec 2003 14:13:24 +0000 |
| Subject: | RE: [PHP-DB] anyone trickier than 'LIKE' ? | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-32027@lists.php.net to get a copy of this message | ||
$keywords = str_replace(' ','%',$keywords);
select * from table where data like "%keywords%";
-----Original Message-----
From: Hadi [mailto:support@hyperproperty.net]
Sent: 12 December 2003 13:21
To: php-db@lists.php.net
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