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');
Did this help you? Please let me know with a comment. Thank you
Posted .

Comments (RSS)

Leave a comment