Re: Converting upper case letters to lower case because of db??
| From: | Jason Wong | Date: | Thu, 07 Feb 2002 18:11:49 +0000 |
| Subject: | Re: Converting upper case letters to lower case because of db?? | ||
| References: | 1 2 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-16614@lists.php.net to get a copy of this message | ||
On Friday 08 February 2002 00:14, Raquel Rice wrote:
> On Thu, 7 Feb 2002 17:07:35 +0100
>
> Andy "Andy" <news.letters@gmx.de> wrote:
> > Hi there,
> >
> > I have a tabel with 250 entries showing a country code lik "CA"
> >
> > Now my application does not work on linux, because they have to be
> > in lower
> > case.
> >
> > Can I make anyhow an bufix, or even better creating a php function
> > to change
> > all 250 entries to lower case.
> >
> > I could not find the propper function on the php site.
> >
> > Can anybody please help on changing this thing into lower case?
> >
> > Thanx
> >
> > ANdy
>
> How about "strtolower()"?
You can run a query directly on the db. Something like:
update mytable set myfield = LOWER(myfield) WHERE 1;
--
Jason Wong -> Gremlins Associates -> www.gremlins.com.hk
/*
Distrust all those who love you extremely upon a very slight acquaintance
and without any visible reason.
-- Lord Chesterfield
*/