HTMLify
Q1667_Fix_Names_in_a_Table.sql
Views: 485 | Author: djdj
1 2 3 | SELECT user_id, CONCAT(UPPER(LEFT(name,1)),LOWER(SUBSTRING(name,2))) AS name FROM Users ORDER BY user_id; |
1 2 3 | SELECT user_id, CONCAT(UPPER(LEFT(name,1)),LOWER(SUBSTRING(name,2))) AS name FROM Users ORDER BY user_id; |