MySQL String Function

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 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 FORMAT() Function Format(X,D[,locale]) is a Sring function of MySQL. This method formats the number X to round of D decimal place…

MySQL OCT() Function Oct(n) is a Sring function of MySQL. This method returns octal value of given number (n). Syntax select oct(n);…

MySQL FROM_BASE64() Function From_base64(str) is a Sring function of MySQL. This method encode the given string to binary formate. Syntax select from_base64(str)…

MySQL HEX(str), HEX(N) Function Hex() is a Sring function of MySQL. This method return in hexadecimal string of given number or String.…