This page shows you the most commonly used MySQL string functions that allow you to manipulate character string data effectively. CONCAT Concatenate two or more strings into a single string. CONCAT_WS ...

-- SELECT CONCAT(author_fname, ' ', author_lname) AS full_author_name FROM books -- SELECT CONCAT_WS(' ', author_fname, author_lname) AS full_author_name FROM books ...

The string str length measured in characters is returned by CHAR_LENGTH. It also counts a single character for a multibyte character. This means, for a string containing five 2-byte characters, LENGTH ...

When you want to replace a string from other string in a string then you can use REPLACE function. REPLACE function returns the string str with all occurrences of the string from Str and replace it by ...