RE: [PHP] substr() in MySQL SELECT?
| From: | Don Read | Date: | Wed, 19 Sep 2001 12:16:11 +0000 |
| Subject: | RE: [PHP] substr() in MySQL SELECT? | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-67832@lists.php.net to get a copy of this message | ||
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 around all different parts.
>
Try to figure out the damn difference between PHP substr() & SQL SUBSTRING().
> thanks much,
>
your welcome,
--
Don Read dread@texas.net
-- It's always darkest before the dawn. So if you are going to
steal the neighbor's newspaper, that's the time to do it.