I know it's been a while since I wrote serious queries, but I'm sure I have done something like this before:
SELECT SUBSTR(date,1,10) as vDate, event_id, events.mach_id, machine.factory_id FROM events JOIN machine ON events.mach_id = machine.mach_id WHERE machine.factory_id = "1" AND vDate = "2012-10-11"
Where I've aliased the SUBSTR of the date and then used the alias in the WHERE clause of the query. I'm getting an error message now, but I'm almost certain I've used that syntax before. Am I missing something?
--
Mark Haney Software Developer/Consultant AB Emblem markh@abemblem.com Linux marius.homelinux.org 3.5.1-1.fc17.x86_64 GNU/Linux
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql
Oct 11
Rick James RE: column aliases in query
Oct 11, 2012; 11:40
Rick James
RE: column aliases in query
Oct 11
hsv Re: column aliases in query
Oct 11, 2012; 16:39
hsv
Re: column aliases in query
Search
Lasso Programming
This site manages and broadcasts several email lists pertaining to Lasso Programming and technologies related and used by Lasso developers. Sign up today!