MySQL search criteria - column alias Dec12 '05

Feedback

2 months, 1 week after the fact. (Tue 21 Feb 2006, 4:50 PM CST)

I totally agreed with you, until I remember the little used HAVING clause...
http://dev.mysql.com/doc/refman/5.0/en/problems-with-alias.html

9 months, 2 weeks after the fact. (Thu 28 Sep 2006, 9:09 AM CST)

can we use alias column name is queries

Feedback

Input format: The editor controls below will assist with Markdown syntax.

Status

Sub-status

Your info Name: Email (will not show on page):

Follow new comments via email? (You can turn this off any time)

Do you want your comments emailed to yourself?

Home Page (optional):

In MySQL, you can’t use a column alias, as the result of an expression, as criteria for your query. You must specify the entire expression twice.

You are at the feedback permalink page for: MySQL search criteria - column alias