How to make selection on a temporary created field

telmessos · #1 (**permalink**) 04-13-10, 02:35

Hi all,

I have an SQL query as follows:

Code:

Select bilgiler.*,(year(islemtarihi)-year(dogumtarihi)) as age from bilgiler where age between 1 and 25

MySQL does not accept the query. I need to create the field "yas" dynamically (field actually does not exist) and filter the people whose age is between 1 and 25.

Is there a way to do this?

Thanks
telmessos

it-iss.com · #2 (**permalink**) 04-13-10, 03:53

Hi Telmessos,

You cannot include the alias name in the where clause. This should be written

select bilgiler.*, (year(islemtarihi)-year(dogumtarihi)) as age
from bilgiler
where (year(islemtarihi)-year(dogumtarihi)) between 0 and 25;

telmessos · #3 (**permalink**) 04-13-10, 04:00

Hi,

I'll try your query. Thanks for your time and help.

telmessos

r937 · #4 (**permalink**) 04-13-10, 05:24

Code:

SELECT *
  FROM ( SELECT bilgiler.*
              , year(islemtarihi)-year(dogumtarihi) AS age 
           FROM bilgiler ) AS d
 WHERE age BETWEEN 1 AND 25

telmessos · #5 (**permalink**) 04-13-10, 05:35

I think thats another option. thanks to both of you.

Internet Services

Web Development

Digital Marketing

Consumer Tech