substr() in MySQL SELECT?
| From: | Tom Churm | Date: | Wed, 19 Sep 2001 11:47:45 +0000 |
| Subject: | substr() in MySQL SELECT? | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-67820@lists.php.net to get a copy of this message | ||
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