Mysql Tutorial

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 GREATEST() Function The greatest() is a Math function of MySQL. This function is used to get the largest number from the…

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

MySQL LEAST() Function The least() is a Math function of MySQL. This function is used to get the smallest number from the…

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…