Cesar,

Yes, its:
select * from table_name where col1 like '%' and col2 like '%' and col3 
like '%';
As your default is %, then this is easy.

Its all in the mysql manual, Section 6.3.2.1 String Comparison Functions.

HTH
Chris

CÚsar Aracena wrote:

>Hi all.
> 
>I'm trying to figure out how to do a search trough a MySQL db using LIKE
>or = but the thing is that I have 3 select boxes from where to choose
>the search terms. Can I use something like a wildcard instead of making
>several IF statements like this?
> 
>SELECT * FROM table_name WHERE col1 = value1 AND col2 = value2 AND col3
>= %
> 
>% goes for an unselected select box (default value = %) in case the user
>doesn't want to make an *advanced* search, so it fetches all rows which
>does contains values 1 & 2.
> 
>Thanks, 
> 
> <mailto:[EMAIL PROTECTED]> Cesar Aracena
>CE / MCSE+I
>Neuquen, Argentina
>+54.299.6356688
>+54.299.4466621
> 
>



--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to