field

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…

MySQL RPAD() Function The RPAD() is a String function of MySQL. This method returns the given string which is right-padded with the…

MySQL LOCATE() Function LOCATE(substr,str) is a Sring function of MySQL. This method returns the first occurrence of given substr in the given…

MySQL RTRIM() Function The Rtrim() is a String function of MySQL. This method removes the extra space if present in the tail…

MySQL SOUNDEX() Function The Soundex() is a String function of MySQL. This method returns a Soundex string. Two strings which sound almost…

MySQL ELT() Function Elt() function is a Sring function of MySQL. This method Nth element from the list of string. Syntax select…