[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