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

Reply via email to