LIKE statement
| From: | Chris Barnes | Date: | Sun, 03 Nov 2002 18:38:39 +0000 |
| Subject: | LIKE statement | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-22928@lists.php.net to get a copy of this message | ||
Hi,
I've got a dilly of a problem. I'm probably doing something wrong but I
don't know what. I'm trying to use the LIKE statement in a query where
more than one word is used in with LIKE..e.g.
select count(distinct itemid) from business where name or description
like 'word1 word2 word3%'
The problem I'm having is probably obvious to you but I don't know why
this returns no matches but if i specify only 1 word in the LIKE
statement then it returns a match.
Am i not able to specify more than 1 word with LIKE or am I just doing
it wrong?
It has been designed to take input from a web form by the variable
$search_string and then the query string is constructed from that e.g.
$query = "select count(distinct itemid) from business where name or
description like'" . $search_string . "'";
Any help or suggestions greatly appreciated.
Attachment: [application/pgp-signature] This is a digitally signed message part signature.asc
Attachment: [application/pgp-signature] This is a digitally signed message part signature.asc