[PHP] substr() in MySQL SELECT?

[Tom Churm]

hi,

could someone please tell me why this doesn't work?  i thought that
string functions could be used in select statements?  i dunno...

SELECT User, SendDate FROM my_form 
WHERE substr(SendDate, 0, 2)=19;

and i've tried the damn thing with brackets around all different parts.

thanks much,

tom

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]