Welcome to the Treehouse Community
Looking to learn something new?
Rasbin RijalCourses Plus Student 10,863 Points
Concatenate first_name and last_name in mysql
I could not pass task 3. Need some help
Select the first letter of the "first_name", followed by a period, followed by a space and then add the "last_name". Also, convert "last_name" to upper case. Alias it as "name". Here's an example: "A. CHALKLEY". The name of the table is "users". Here is my code
CONCAT(SUBSTRING(first_name, 1, 1), ".", " ", UPPER (last_name);
Steven Parker215,972 Points
You did good so far, but you still have a few steps left:
- check for missing/mismatched parentheses
- alias the result of your CONCAT as "name"
- put all that in a
- remember to add the
FROMclause identifying the users table to complete the SELECT statement