MySQL Case Sensitive WHERE IN Clause

MySQL WHERE IN case sensitive select clause.

SELECT
    *
FROM
    `table`
WHERE
    CAST(`column` AS BINARY) NOT IN ('Foo', 'Bar', 'Baz');

Comments

Leave a Reply