[thelist] selecting above and below ranges in a SQL query [long]
rudy
r937 at interlog.com
Mon Aug 26 13:24:00 CDT 2002
>WHERE erlang_no <= '1.5' (Is this really a string???)
that's one of mysql's "proprietary extensions"
you're allowed to code numerics as strings or strings as numerics, and
mysql converts them for you to "whatever makes sense"
this encourages all kinds of swell programming habits like
adding +0 to a string or concatenating '' to a number... just to be sure...
brought to you by the same folks who allow you to GROUP BY
whatever you feel like
rudy
More information about the thelist
mailing list