Mysql WHERE子句帮助

Question

How can I use a WHERE MySQL clause in a statement which can fetch me all the records? I am settings the WHERE condition conditionally. Like...

if (this) {
    $mycondition=1;
} elseif (that {
    $mycondition=????
}

'SELECT * FROM table WHERE category='.$mycondition

What should be the value of ???? so that when I pass it to the sql statement it fetches me all the records. I was thinking that WHERE category='*' might work but it does not.

Answer 1

You could just use this

if(this){
   $mycondition=" category=1";
}elseif(that{
   $mycondition= " 1"; //1 = 'true'. You could also use "1=1
}

'SELECT * FROM table WHERE '.$mycondition