mysql upper case/lower case query

[lonnie]

I am using the mysql INTO OUTFILE function to back out some of the fields of our registration database. I need to have some of the outputed fields with an inital capital (upper case) letter only followed by lower case: for example, their name should be James, not james as they entered it in the form they submitted.

If it is not possible to do that string massaging on the dump, is their a query to update the column to produce an initial uppercase followed by lowercase command or function?

Can it be controlled at the form/data entry end?

The form is a PHP page using the INSERT function.

All suggestions will be greatly appreciated.

Regards,
Lonnie

[Lars_Berg]

select concat(upper(substring(name from 1 for 1)),lower(substring(name from 2)))