Comments on: Pop quiz: funny syntax https://shlomi-noach.github.io/blog/mysql/pop-quiz-funny-syntax Blog by Shlomi Noach Mon, 12 Nov 2012 05:09:53 +0000 hourly 1 https://wordpress.org/?v=5.3.3 By: Rick James https://shlomi-noach.github.io/blog/mysql/pop-quiz-funny-syntax/comment-page-1#comment-133333 Mon, 12 Nov 2012 05:09:53 +0000 https://shlomi-noach.github.io/blog/?p=5445#comment-133333 Another quiz. (People do try this in WHERE clauses.)
SELECT 123 < col < 456;

That probably evaluates to
SELECT (123 < col) 1 (and sometimes >0).

]]>