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