Learn MySQL Tutorial
The MySQL CAST function is used to explicitly convert an expression or a value from one data type to another. This function is particularly useful when you need to convert data types explicitly, ensuring that the result is of the desired type. Syntax The basic syntax of the CAST function is as follows: CAST(expression AS […]
The RPAD function in MySQL is used to pad a string with a specified number of characters on the right side. This function is particularly useful when you need to ensure that a string has a certain length by appending a specific character or a set of characters to the right. Syntax Here is the […]
The LPAD function in MySQL is used to pad the left side of a string with a specified set of characters until the string reaches a desired length. This can be useful, for example, when you need to format data in a specific way, such as aligning numbers or creating fixed-width columns. Syntax Here is […]
The SUBSTR function in MySQL is used to extract a substring from a given string. It allows you to retrieve a specific portion of a string based on a specified starting position and, optionally, a specified length. Syntax Here is the syntax for the SUBSTR function in MySQL: SUBSTR(str, start[, length]) str: This is the […]
The REGEXP_SUBSTR function in MySQL is used to extract a substring of a string based on a regular expression pattern. It’s similar to the SUBSTRING function, but instead of extracting a specified substring, it identifies and extracts the portion of the string that matches the given regular expression. Usages of REGEXP_SUBSTR Parsing Text: Extracting specific […]
The MySQL REGEXP_REPLACE function is a powerful tool for pattern matching and string manipulation within MySQL databases. It allows you to search a string for a regular expression pattern and replace every occurrence of that pattern with a specified replacement string. This function is particularly useful for tasks such as cleaning up data, formatting text, […]
© MySQL Tutorial 2025.