nanook Posted January 9, 2008 Share Posted January 9, 2008 I imported a large list of names and addresses into a table. The data was entered in all upper case. If it's possible I'd like to change that to proper case. Is that possible? if so, How do I do it? Quote Link to comment https://forums.phpfreaks.com/topic/85115-changing-the-case-of-data-in-a-table/ Share on other sites More sharing options...
AndyB Posted January 9, 2008 Share Posted January 9, 2008 read data use strtolower() funtion to convert to all lower case use ucfirst() function to convert to sentence case write back to database Quote Link to comment https://forums.phpfreaks.com/topic/85115-changing-the-case-of-data-in-a-table/#findComment-434199 Share on other sites More sharing options...
fenway Posted January 9, 2008 Share Posted January 9, 2008 Equivalent set of functions can be used in mysql directly... LOWER, UPPER with SUBSTR, etc. Quote Link to comment https://forums.phpfreaks.com/topic/85115-changing-the-case-of-data-in-a-table/#findComment-434554 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.