The below MySQL function will show how to capitalize first letter of each word in a string. Continue reading “MySQL Function to Capitalize the First Letter of Words 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.
Continue reading “Generate zero-fill auto-incremented id in MySQL”
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. Continue reading “Custom regex function to replace characters in MySQL”