Chris Barnes wrote:
Yeah I really need to search for multiple words. Can anyone confirm if
the IN statement will work for me in this situation?
Chris --
Why not just try it you self and let's us know.
Also check to MySQL doc at http://mysql.org
David
On Mon, 2002-11-04 at 09:31, [EMAIL PROTECTED] wrote:
if you want to search for multiple words, u have to use multiple like
operators:
select count(distinct itemid) from business where name like 'word1' or
name like 'word2' or name like 'word3';
or the IN statement with wildcards:
select count(distinct itemid) from business where name IN
('%word1%','%word2%','%word3%'); <-- im not too sure of this, would the
experts please shed some more light on this one if its correct?
Amit
On 4 Nov 2002, Chris Barnes wrote:
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.
------------------------------------------------------------------------
---
Peter Beckman Systems Engineer, Fairfax Cable Access
Corporation
[EMAIL PROTECTED]
http://www.purplecow.com/
------------------------------------------------------------------------
---
--
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
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php