educative.io

Change the capitalized letter

Courses
,
#1

Dear Instructor,

We

changeback
changeback1343×625 35 KB

've changed the name and url capitalized as uppercase, how can I change them back to normal?

Course: https://www.educative.io/collection/5352985413550080/6335716377231360
Lesson: https://www.educative.io/collection/page/5352985413550080/6335716377231360/6643072801701888

#2

Hi @Zhang_MR, Thank you for contacting the Educative team with your query.

Once you converted the name in uppercase you can convert it into lowercase by using LOWER() function. If you want not to alter the original one make a separate column for the UPPER() uppercase names. Actually, there is no single function in MySQL to capitalize only the first letter of the string. We need to use nesting of functions and for this case, we can use UPPER() and LOWER() with SUBSTRING() functions.

Hope the answer to the query :blush: