d
Amit DhamuSoftware Engineer
 

Capitalise Field in Row

1 minute read 00000 views

Will convert aMiT to Amit

UPDATE users SET user_f_name = CONCAT(UCASE(LEFT(user_f_name, 1)), LCASE(SUBSTRING(user_f_name, 2)));