Posted by Oli Filth on 06/27/05 14:22

joealey2003@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

[Back to original message]