News for hackers. Stuff that matters.
Re:Easy Steps to a Complete Understanding of SQL by jcampbell1 on Tuesday September 03, 2013 @11:40AM (#6321554)
You fixed the article incorrectly. SELECT aliases are never available in a WHERE clause.

Edit: it seems more complicated that I initially assumed. MySQL doesn't allow it. SQLite does.

Re:Easy Steps to a Complete Understanding of SQL by lukaseder on Wednesday September 04, 2013 @03:58AM (#6326213)
You're right, the new wording was ambiguous. A better wording is this:

Rule number 2, for instance, does not apply exactly in the above way to MySQL, PostgreSQL, and SQLite.