Jump to content

Archived

This topic is now archived and is closed to further replies.

mcmuney

Changing Data

Recommended Posts

I have an input field where users type in information, but they use upper, lower and mixes. How can I update all the existing data on the DB to be all "Capitalized"?

Share this post


Link to post
Share on other sites
strtoupper() [url=http://ca3.php.net/manual/en/function.strtoupper.php]http://ca3.php.net/manual/en/function.strtoupper.php[/url]

Share this post


Link to post
Share on other sites
MySQL has an UPPER() function as well, AFAIK, and you can probably use this on the way in (in the INSERT/UPDATE statement).

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.