$var = "Yarin"; num_rows( "SELECT `field` FROM `table` WHERE LOWER(`someField`) = '". strtolower($var) ."'" );