The below MySQL function will show how to capitalize first letter of each word in a string.
This tutorial shows how to generate zero-fill auto-incremented unique identifier in MySQL. Sometimes we need to generate such keys which are used in some part of the application for business logic.
This tutorial shows how to replace the characters in a string or text using regular expression in MySQL function. There is no built-in function available to replace any character in a string or text in MySQL so here I am creating a custom function.