Comparison Functions Operators MySQL Tutorial

  1. Home
  2. MySQL Tutorial
  3. Comparison Functions Operators
  4. 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');