Interesting Update Query

[joealey2003]

Hi all...
I have a column that contains names in upper case like:
JOE, LAST NAME
THOMAS JEFERSON MORS
MIKE LEE
..
..
..

and i wat it to be like:

Joe, Last Name
Thomas Jeferson Mors
Mike Lee
Any hint???

[Alvaro G Vicario]

*** jo*********@yahoo.com wrote/escribió (27 Jun 2005 01:42:49 -0700):

JOE, LAST NAME
THOMAS JEFERSON MORS
MIKE LEE and i wat it to be like: Joe, Last Name
Thomas Jeferson Mors
Mike Lee

Main : Function Reference : String Functions : strtolower

strtolower
Make a string lowercase
available since: PHP 3, PHP 4 , PHP 5

usage:
string strtolower ( string str )

Main : Function Reference : String Functions : ucwords

ucwords
Uppercase the first character of each word in a string
available since: PHP 3>= 3.0.3, PHP 4 , PHP 5

usage:
string ucwords ( string str )
Use a combination of both functions.
--
-- Álvaro G. Vicario - Burgos, Spain
-- http://bits.demogracia.com - Mi sitio sobre programación web
-- Don't e-mail me your questions, post them to the group
--

[joealey2003]

Ok, but i am trying a mysql only solution.

The worst is that if i use a function that like locate() to find space
chars, it will only works for the first space char...


Alvaro G Vicario wrote:

*** jo*********@yahoo.com wrote/escribió (27 Jun 2005 01:42:49 -0700):

JOE, LAST NAME
THOMAS JEFERSON MORS
MIKE LEE

and i wat it to be like:

Joe, Last Name
Thomas Jeferson Mors
Mike Lee

Main : Function Reference : String Functions : strtolower

strtolower
Make a string lowercase
available since: PHP 3, PHP 4 , PHP 5

usage:
string strtolower ( string str )

Main : Function Reference : String Functions : ucwords

ucwords
Uppercase the first character of each word in a string
available since: PHP 3>= 3.0.3, PHP 4 , PHP 5

usage:
string ucwords ( string str )
Use a combination of both functions.
--
-- Álvaro G. Vicario - Burgos, Spain
-- http://bits.demogracia.com - Mi sitio sobre programación web
-- Don't e-mail me your questions, post them to the group
--

[Oli Filth]

jo*********@yahoo.com said the following on 27/06/2005 10:50:

Ok, but i am trying a mysql only solution.

The worst is that if i use a function that like locate() to find space
chars, it will only works for the first space char...

You could spend ages writing a really complicated MySQL UPDATE query (it
might not even be possible, I don't know), or you could just use the
strtolower() + ucwords() combo before you INSERT data, or after you
SELECT data. Or alternatively, write a script that does a one-off
replace of all database records (i.e. SELECT -> PHP strtolower() +
ucwords() -> UPDATE).

--
Oli

[Geoff Berrow]

I noticed that Message-ID:
<11*********************@g14g2000cwa.googlegroups. com> from
jo*********@yahoo.com contained the following:

Ok, but i am trying a mysql only solution.

and asking the question in comp.lang.php.

O...K...

--
Geoff Berrow (put thecat out to email)
It's only Usenet, no one dies.
My opinions, not the committee's, mine.
Simple RFDs http://www.ckdog.co.uk/rfdmaker/