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 ...
#Now if you have values that have white space on the front or end, we can get rid of that white space using TRIM SELECT TRIM('sky' ); #Now if we have white space in the middle it doesn't work SELECT ...