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 ...

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 ...

TO_BASE64 function in mysql is used for encode any string with the string encode rule BASE64. This function returns a encoded string. This function is added with the mysql version 5.6.1 In mysql there ...