MySQL LOCATE() Function LOCATE(substr,str) is a Sring function of MySQL. This method returns the first occurrence of given substr in the given…
Tag:
character_length()
-
-
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)…