Im trying to do a complex query like the one below but it doesnt seem to work. Can i do a query and then search within that OR is there a way to reorganize the statement below?
$result = mysql_query("SELECT * FROM cturtle where asia='1' AND (fname LIKE '%$all%' || lname LIKE '%$all%' || email LIKE '%$all%') ORDER BY lname", $db);
$result = mysql_query("SELECT * FROM cturtle where asia='1' AND (fname LIKE '%$all%' || lname LIKE '%$all%' || email LIKE '%$all%') ORDER BY lname", $db);