MySQL String Function

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 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 LPAD() Function LPAD(str,len,padstr) is a Sring function of MySQL. This method returns string ‘str’ which is left padded to the given…

MySQL SPACE() Function The space() is a String function of MySQL. This function returns the given number (n) of blank spaces. Syntax…

MySQL EXPORT_SET() Function Export_set() is a Sring function of MySQL. This method returns string for each bit set. Syntax select export_set(bits,on,off[,separator[,number_of_bits]]); Example…

MySQL STRCMP() Function The strcmp() is a String function of MySQL. This function compares the given two strings. This function returns 0…