Learn MySQL Tutorial
The LTRIM function in MySQL is used to remove leading spaces (or a specified character) from a string. It effectively eliminates whitespace characters that appear at the beginning of a string, ensuring that the resulting string starts with meaningful characters. This function finds extensive applications in data cleaning and data manipulation tasks, particularly when dealing […]
The MySQL RIGHT is a string function, which extracts a specified number of characters from the right side of a string. Its syntax is as follows: Syntax RIGHT(str, length) str: This is the input string from which you want to extract characters. length: This parameter specifies the number of characters to extract from the right […]
The MySQL LEFT function is part of string functions and is used to extract a specified number of characters from the left side of a string. It is a powerful function for manipulating and filtering data, and it is commonly used in various scenarios, including: Substring Extraction: The LEFT() function is ideal for extracting parts […]
The MySQL INSTR function is used to find the position of the first occurrence of a substring within a string. It returns the position of the substring if found, and 0 if the substring is not present in the given string. The INSTR function is case-sensitive, meaning it distinguishes between uppercase and lowercase characters. Syntax […]
The MySQL FORMAT function is used for numeric formatting and is different from formatting date and time values. The FORMAT function is used to format a numeric value with a specific number of decimal places and commas as thousands separators. Syntax Here’s the basic syntax: FORMAT(number, [decimal_places]) number: The numeric value that you want to […]
The MySQL CONCAT_WS function is a string function that stands for Concatenate With Separator. It is used to concatenate multiple strings into a single string, with a specified separator between each pair of strings. The primary purpose of CONCAT_WS is to simplify the process of concatenating strings while automatically adding a separator between them. Syntax […]
© MySQL Tutorial 2025.