Skip to content

Roy Tutorials

Technical… Theoretical… Practical…

  • Home
  • FAQs
  • About Me
  • Home
  • mysql function

Tag: mysql function

The below MySQL function will show how to capitalize first letter of each word in a string.

1 Comment on MySQL Function to Capitalize the First Letter of Words in a String
Posted in MySQL

MySQL Function to Capitalize the First Letter of Words in a String

Zero-Fill Auto-Incremented Id This tutorial shows how to generate zero-fill auto-incremented unique identifier in MySQL. Sometimes you may need to generate such keys which are used in some part of the application for business logic. Below example shows how to generate zero-fill auto-incremented id in MySQL table.

Leave a Comment on Generate Zero-Fill Auto-Incremented Id In MySQL
Posted in MySQL

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.

Leave a Comment on Custom regex function to replace characters in MySQL
Posted in MySQL

Custom regex function to replace characters in MySQL

Categories

Copyright © 2014 - 2023 Roy Tutorials

Privacy | Terms & Conditions