[PHP] substr() in MySQL SELECT?

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,

RE: [PHP] substr() in MySQL SELECT?

On 19-Sep-2001 Tom Churm wrote: 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

Re: [PHP] substr() in MySQL SELECT?

hi, don: thanks a lot for the tip. and thanks even more for echoing the poor tone i used in my post--i will try to avoid writing such posts in the future. after looking at the documentation (many connection problems today), i was able to write this, like i wanted: SELECT User, SendDate FROM