Mega Code Archive

 

Categories / MySQL Tutorial / Comparison Functions Operators

 

You should never mix quoted and unquoted values in an IN list

SELECT val1  FROM tbl1  WHERE val1 IN (1,2,'a'); Instead, write it like this: SELECT val1 FROM tbl1 WHERE val1 IN ('1','2','a');