You want to RENAME tables where applicable, and ALTER the respective columns
to the desired case. Both are done through queries. The MySQL Manual has
detailed info on using these commands.

Gerald Jensen

----- Original Message -----
From: "Keith Spiller" <[EMAIL PROTECTED]>
To: "Php-db" <[EMAIL PROTECTED]>
Sent: Thursday, August 16, 2001 2:48 PM
Subject: Opps: Proper Case NOT lower case

-Opps:  I meant to say I would like to convert to Proper Case, rather than
lower case or UPPER CASE.

I'm reading data from a mysql table that is entirely in uppercase letters.
I'd very much like to convert them
to Proper Case.  After searching a while, I found that there is are php
commands to convert text strings between
upper and lower case, but I was unable to find anything that can convert to
proper case.

Does any one know of a way to do this, or a script that will accomplish it?
Or, is there a mysql command
that can handle the matter for me?



PHP Database Mailing List (
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to