Set first letters in Names to Capitals

From TNG_Wiki
Jump to navigation Jump to search

Probably there's a shorter way, but this one does what it's supposed to do, change all names written like "john jacky jones" into "John Jacky Jones",

Copy and paste the text between the lines into the MySQL section of your MySQL admin, IMPORTANT: Make a backup before you try anything and use this at your own risk!

UPDATE tng_people SET firstname= concat(upper(left(firstname, 1 )),mid(firstname, 2 ));
UPDATE tng_people SET lastname= concat(upper(left(lastname, 1 )),mid(lastname, 2 ));