Write A Query to Get First Letter Capital and rest other in lower case

Write a Query to get first letter of first_name captial and rest in lower case same with the last name and then concat this, with space in between. SELECT SOLUTION---- concat(concat(LEFT(first_name,1),lower(substring(first_name,2,length(first_name)))), ' ',concat(LEFT(last_name,1),lower(substring(last_name,2,length(last_name))))) as Full_name FROM actor

Видео Write A Query to Get First Letter Capital and rest other in lower case автора Начало пути в программирование на PHP