#Fixing names column so only first letter is uppercase. Table: Users +----------------+---------+ | Column Name | Type | +----------------+---------+ | user_id | int | | name | varchar | +----------------+---------+ select user_id, CONCAT (UPPER(LEFT(name,1)), LOWER(right(name,LENGTH(name)-1))) as name from Users ORDER BY user_id;
Preview:
downloadDownload PNG
downloadDownload JPEG
downloadDownload SVG
Tip: You can change the style, width & colours of the snippet with the inspect tool before clicking Download!
Click to optimize width for Twitter