Mysql Tutorial

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…

MySQL SUBSTR() Function The substr() is a String function of MySQL. This function returns the substring from the given string. Syntax select…

MySQL LTRIM() Function LTRIM(str) is a Sring function of MySQL. This method returns string by removing leading space. Syntax select ltrim(str); Example…

MySQL SUBSTRING_INDEX() Function The substring_index() is a String function of MySQL. This function returns a substring from the given string(str) before the…

MySQL FIND_IN_SET() Function Find_in_set(str,strlist) is a Sring function of MySQL. This method return the value of the string which is given in…

MySQL FORMAT() Function Format(X,D[,locale]) is a Sring function of MySQL. This method formats the number X to round of D decimal place…