MySQL String Function

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 SUBSTRING() Function The substring() is a String function of MySQL. This function returns the substring from the given string. Syntax select…

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)…