The concat( ) function add two or more expression together.
For add two or more expressions from column
Select Concat (expression1 , expression2 , expression3 , …………);
select concat ( column_name1, ' ', column_name2, ' ' , ……….. ) from table_name as fullname;
The reverse function uses to write anything reversely.
select reverse ( ‘write any string’ );
select reverse ( ‘write any string’ ) as reverse ;
This is used to count the length of words, numbers etc.
select char_length (‘ any character’);
This is used to write lower words to the upper word.
select upper (' any character ');
This is used to write lower words to upper word.
select lower (' any charecter ');