WHERE and HAVING in the same query?

[screative]

Can you have both 'WHERE' and 'HAVING' in the same query?

For example:

SELECT lat,lon,id, ( 3959 acos( cos( radians(40.034462) ) cos( radians( lat ) ) cos( radians( lon ) - radians(-82.867520) ) + sin( radians(40.034462) ) sin( radians( lat ) ) ) ) AS distance FROM office WHERE id =1 AND HAVING distance < 15 ORDER BY distance LIMIT 0 , 20

This zip code radius search seems to through and error with the WHERE in it and works fine when it is removed.

[Piranha]

remove "AND", it should help.

If it doesn't solve the problem please post the exact error message you get as well as the query you use.

[Sxooter]

Where decides which rows to pass to a group by, having decides which rows after the group by should then be displayed. Not sure what you're trying to do here. Just drop the having keyword and it should work.