MySQL String Function

MySQL Trim() Function The trim() is a String function of MySQL. This function removes the blank spaces from the head and tail…

MySQL UCASE() Function The ucase() is a String function of MySQL. This function returns the string in upper case. Syntax select ucase(str)…

MySQL QUOTE() Function Quote(str) is a Sring function of MySQL. This method returns the string which is passed in single quote. Syntax…

MySQL UPPER() Function The upper() is a String function of MySQL. This function returns the string in upper case. Syntax select upper(str)…

MySQL REPEAT() Function REPEAT(str,count) is a Sring function of MySQL. This method returns the string reputation counter times. Syntax select repeat(str, count);…

MySQL String Function MySQL string functions manipulate the character string data effectively. The following table indicates each of the functions with a…

MySQL REPLACE() Function REPLACE(str,from_str,to_str) is a Sring function of MySQL. This method returns string from the given string to the string. Syntax…

MySQL REVERSE(str) Function The REVERSE() is a String function of MySQL. This method returns the given string in reverse order. Syntax select…

MySQL RIGHT() Function The Right() is a String function of MySQL. This method returns allows you to extract a substring from a…

MySQL CHARACTER_LENGTH() Function Character_Length (str) function is a Sring function of MySQL. This method is same as char_length() function which returns size…