On Friday 08 February 2002 00:14, Raquel Rice wrote:
> On Thu, 7 Feb 2002 17:07:35 +0100
>
> Andy "Andy" <[EMAIL PROTECTED]> 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
*/
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
