Re: mysql 4.1-4.0
| From: | blackwater dev | Date: | Wed, 02 Feb 2005 20:46:25 +0000 |
| Subject: | Re: mysql 4.1-4.0 | ||
| References: | 1 2 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-38451@lists.php.net to get a copy of this message | ||
yeah, that is what I did to fix it...just curious why the problem was
there in the first place.
On Wed, 02 Feb 2005 14:40:55 -0600, Martin Norland
<martin.norland@stjude.org> wrote:
> blackwater dev wrote:
> > Why is this query handled differently in 4.1?
> >
> > 4.0
> > select lower(concat(last_name,id)) from client where prim_id=1
> > returns johnson1
> >
> > 4.1
> > same query returns Johnson1
> >
> > Why don't the lower work in 4.1 when you concatonate with a number?
> No idea.
>
> select concat(lower(last_name),id) from client where prim_id=1;
>
> Cheers,
> --
> - Martin Norland, Database / Web Developer, International Outreach x3257
> The opinion(s) contained within this email do not necessarily represent
> those of St. Jude Children's Research Hospital.
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>