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?

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

1 Answer 1


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:


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:


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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