2005/9/17, Alvaro Cobo <coboalvaro@stripped>:
> Hi all:
> I've searched into the MySQL manual but I can't find the solution to this very silly
> I have a select query where I need to filter the data using the WHERE statement. But
> also need to have an option to show all the data in the table.
> For example (something like...):
> SELECT * FROM `tbl_table1` WHERE field1 = 'Test' #To show all the rows where field
> 1= 'Test'
> But also have the choice to select all the rows using something like:
> SELECT * FROM `tbl_table1` WHERE field1 = * or ALL or % #Select all the fields.
You need to select all rows, but you have only control on the
condition on flied1, I am right ?
If you can input %, it should do the trick.
select * from table WHERE field1 like '%';
Why can't you do just
select * from table ??
Webzine Rock : http://www.w-fenec.org/