MySQL String Function

MySQL FIELD() Function Field(str,str1,str2,str3,….) is a Sring function of MySQL. This method returns the index of string. Syntax select field(str,str1,str2,str3,…) Example 1…

MySQL MAKE_SET() Function MAKE_SET(bits,str1,str2,…) is a Sring function of MySQL. This method returns values from set for the given bit. Syntax select…

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…

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

MySQL ORD() Function ORD(str) is a Sring function of MySQL This method returns code for the given string. Syntax select ord(str); Example…

MySQL INSERT() Function INSERT(str,pos,len,newstr) is a Sring function of MySQL. In this method, a string str is passed with a position ‘pos’…

MySQL UNHEX() Function The unhex() is a String function of MySQL. This function converts the hexadecimal value into a string. Syntax select…