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? 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 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. 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
Archived
This topic is now archived and is closed to further replies.