Innodb problem . The sql query with alias is not working

Question

SELECT VoteTypeId AS vcol FROM VoteType v WHERE v.VoteTypeId = 4

and table structure is

vcol        VoteType
----------- --------------------------------------------------
1           Yes/No
2           Multiple Choice
4           Qualitative

but it turn out error and said Unknown column 'VoteTypeId' in 'where clause'

thanks in advance.

Did you mean to write: `SELECT vcol AS VoteTypeId FROM VoteType v WHERE v.vcol = 4` ?? — ypercubeᵀᴹ, Jun 19 '11 at 08:36
i want to have a shorter name (eg.col to replace vcol) to represent the column — Leo Chan, Jun 19 '11 at 08:41

score 1 · Accepted Answer · edited May 23 '17 at 12:04

It looks like your alias is not set up reversed (but it's not entirely clear from your question), and you can't do it that way. You can't use the alias in the where clause.

If the real column name is vcol:

select vcol as VoteTypeId from VoteType v where v.vcol = 4

See Can you use an alias is a WHERE clause in MySQL for an explanation/links regarding why you can't use the alias in the WHERE.

Innodb problem . The sql query with alias is not working

1 Answers1