Give examples of commonly used string functions in MySQL.

Question

Accepted Answer

MySQL provides many built-in string functions used to manipulate, search, extract, and format text data. Below are some of the most commonly used ones with examples. UPPER(str) – Converts text to uppercase. LOWER(str) – Converts text to lowercase. SELECT UPPER('mysql');      -- MYSQL
SELECT LOWER('HeLLo');      -- hello LENGTH(str) – Returns the length in bytes. CHAR_LENGTH(str) – Returns the length in characters. SUBSTRING(str, start, length) – Extracts part of a string. SELECT LENGTH('Hello');              -- 5
SELECT CHAR_LENGTH('नमस्ते');        -- 6
SELECT SUBSTRING('MySQL Server', 1, 5);  -- MySQL CONCAT(str1, str2, ...) – Joins strings. CONCAT_WS(separator, str1, str2) – Joins with a separator. REPLACE(str, from_str, to_str) – Replaces text. SELECT CONCAT('My', 'SQL');                     -- MySQL
SELECT CONCAT_WS('-', '2025', '01', '31');       -- 2025-01-31
SELECT REPLACE('hello world', 'world', 'MySQL'); -- hello MySQL TRIM(str) – Removes leading and trailing spaces. LTRIM(str) – Removes left spaces. RTRIM(str) – Removes right spaces. LPAD(str, length, padstr) – Pads on the left. RPAD(str, length, padstr) – Pads on the right. SELECT TRIM('   MySQL   ');       -- MySQL
SELECT LPAD('7', 3, '0');        -- 007
SELECT RPAD('Hi', 5, '!');       -- Hi!!! INSTR(str, substring) – Returns position of substring. LOCATE(substring, str) – Similar to INSTR, supports starting position. LEFT(str, n) – Returns first n characters. RIGHT(str, n) – Returns last n characters. SELECT INSTR('database', 'base');      -- 5
SELECT LEFT('MySQL', 2);               -- My
SELECT RIGHT('MySQL', 3);              -- SQL These string functions help perform efficient text processing in MySQL queries, making them essential tools for data manipulation.

Give examples of commonly used string functions in MySQL.

Commonly Used String Functions in MySQL

Give examples of commonly used string functions in MySQL.

Commonly Used String Functions in MySQL

Scenario Questions

Follow-up Questions