#1667 Fix Names in a Table
SELECT user_id,
CONCAT(UPPER(LEFT(name, 1)),LOWER(SUBSTRING(name, 2, LEN(name)))) AS name
FROM Users
ORDER BY user_id
Last updated
Was this helpful?
SELECT user_id,
CONCAT(UPPER(LEFT(name, 1)),LOWER(SUBSTRING(name, 2, LEN(name)))) AS name
FROM Users
ORDER BY user_id
Last updated
Was this helpful?