captialize column value

 Rename the mysql table

RENAME TABLE current_table_name TO new_table_name;

Capitalize latter in mysql

select concat(

upper(substring(name,1,1)), substring(name,1,locate(' ',name)),

upper(substring(name,locate(' ',name),2)), mid(name,locate(' ',name)+2)

) as fname ,name from users;

Update with first latter capitalize

update users u join users u1 on u.id = u1.id set u.name = (concat(

upper(substring(u1.name,1,1)), substring(u1.name,1,locate(' ',u1.name)),

upper(substring(u1.name,locate(' ',u1.name),2)), mid(u1.name,locate(' ',u1.name)+2)

) );

 

Extract the first and last name from name column of table

update users u join users u1 on u.id=u1.id

set u.fname = left(u1.name,locate(" ",u1.name)), u.lname=

mid(u1.name,locate(" ",u1.name));