i have made a query that contains a search field and a combobox where you can select the row. the query is working if you want to search in one row, but i want to search in multimple rows! i want that if i select the case 0 to search in all the rows switch($field) { case "0": $WHERE="WHERE (what should i write in here?) "; break; // case "1": $WHERE="WHERE Name; break; case "2": $WHERE="WHERE OBS"; break; case "3": $WHERE="WHERE Dept"; break; } $query = "select * from DB1 ".$WHERE." LIKE '%$search%'"; $result = mysql_db_query("DB", $query); if ($result) {