What is difference between `flag is TRUE` vs `flag = TRUE` in MySQL?
I ran the following queries in MySQL -
SELECT * from table
WHERE valid is TRUE
ORDER BY priority DESC
limit 10
offset 0;
Time taken = 1 second.
vs
SELECT * from table
WHERE valid = TRUE
ORDER BY
stackoverflow.com