Selecting (all) from a field

[Freedom-n-Democrazy]

Does anyone know how I can select (all) from a field?

Something like:

 

select id from products where category = *

 

 

I am using it for:

 

if ($_POST['category'] == "(Any)") {
$_POST['category'] = "*";

 

... then I'd be using:

select id from products where category = ".$_POST['category']."

[Freedom-n-Democrazy]

NOTE: From a specific field, in this case - .category".

[Muddy_Funster]

you would be better to build the full where clause dependant on the input, rather than the filter placed on the field:

if($_POST['category'] == "(Any)"){
  $where = '';
}
else{
  $where = " WHERE category = '{$_POST['category']}'";
}
$sql = $sql.$where;

[ManiacDan]

Leave off the WHERE clause entirely if you want to match all rows.