0

I have a project where authors' names have been inserted in all capital letters (ex. JOHN KRAUS, LEONARD MILES, NAOMI DAWSON). Now I need these values in "normal" case (ex. John Kraus, Leonard Miles, Naomi Dawson)

How can I achieve that?

2
  • This might answer your question. You can find related information by searching for "mysql title case" or "mysql proper case".
    – mustaccio
    Aug 13 '20 at 21:15
  • It would be easier to do the task in some other programming languabe.
    – Rick James
    Aug 13 '20 at 21:19
0

Mysql has a mechanism called cursors that allows to read all the rows from the table one by one. Detailed description can be found here:

https://dev.mysql.com/doc/refman/8.0/en/cursors.html

You have to write a stored routine with a cursor loop inside and to place some case transforming logic in it. Useful functions are LOWER(), UPPER(), SUBSTRING() and other text functions described here:

https://dev.mysql.com/doc/refman/8.0/en/string-functions.html

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.