FROM_BASE64() FUNCTION The MySQL FROM_BASE64 function is used to encode a specified string to binary format. Syntax: FROM_BASE64( string ) Parameters: string: It is used to specify the string to encode. Example: mysql> SELECT FROM_BASE64 (‘mysql’) as ‘OUTPUT’; Output: OUTPUT NULL
EXPORT_SET() FUNCTION The MySQL EXPORT_SET function is used to get a string for each bit set. Syntax: EXPORT_SET( bits, on, off, separator, number_of_bits ) Example: mysql> SELECT EXPORT_SET ( 5, ‘a’, ‘b’, ‘,’, 4 ); Output: a,b,a,b
UPPER() FUNCTION The MySQL UPPER function is used to convert all characters in the specified string to uppercase. The various versions of MySQL support the UPPER function, namely, MySQL 5.7, MySQL 5.6, MySQL 5.5, MySQL 5.1, MySQL 5.0, MySQL 4.1, MySQL 4.0 and MySQL 3.23. Syntax: UPPER( string ) Parameters: string: It is used to … Read more
UCASE() FUNCTION The MySQL UCASE function is used to convert all characters in the specified string to uppercase. The various versions of MySQL support the UCASE function, namely, MySQL 5.7, MySQL 5.6, MySQL 5.5, MySQL 5.1, MySQL 5.0, MySQL 4.1, MySQL 4.0 and MySQL 3.23. Syntax: UCASE( string ) Parameters: string: It is used to … Read more
TRIM() FUNCTION The MySQL TRIM function removes all the specified characters either from the beginning or the end of a string or from both sides. The various versions of MySQL support the TRIM function, namely, MySQL 5.7, MySQL 5.6, MySQL 5.5, MySQL 5.1, MySQL 5.0, MySQL 4.1, MySQL 4.0 and MySQL 3.23. Syntax: TRIM ( … Read more
SUBSTRING_INDEX() FUNCTION The MySQL SUBSTRING_INDEX function is used to get the substring of string before several occurrences of delimiter. The various versions of MySQL support the SUBSTRING_INDEX function, namely, MySQL 5.7, MySQL 5.6, MySQL 5.5, MySQL 5.1, MySQL 5.0, MySQL 4.1, MySQL 4.0 and MySQL 3.23. Syntax: SUBSTRING_INDEX( string, delimiter, number ) Parameters: string: It … Read more
STRCMP() FUNCTION The MySQL STRCMP function is used to compare two strings. The various versions of MySQL support the STRCMP function, namely, MySQL 5.7, MySQL 5.6, MySQL 5.5, MySQL 5.1, MySQL 5.0, MySQL 4.1, MySQL 4.0 and MySQL 3.23. Syntax: STRCMP( string1, string2 ) Parameters: string1, string2: It is used to specify the strings to … Read more
SPACE() FUNCTION The MySQL SPACE function is used to get a string with a specified number of spaces. The various versions of MySQL support the SPACE function, namely, MySQL 5.7, MySQL 5.6, MySQL 5.5, MySQL 5.1, MySQL 5.0, MySQL 4.1, MySQL 4.0 and MySQL 3.23. Syntax: SPACE( number ) Parameters: number: It is used to … Read more
REVERSE() FUNCTION The MySQL REVERSE function is used to reverse the order of the position of the characters in a string. The various versions of MySQL support the REVERSE function, namely, MySQL 5.7, MySQL 5.6, MySQL 5.5, MySQL 5.1, MySQL 5.0, MySQL 4.1, MySQL 4.0 and MySQL 3.23. Syntax: REVERSE( string ) Parameters: string: It … Read more
REPLACE() FUNCTION The MySQL REPLACE function is used to replace all occurrences of a substring in a string. The various versions of MySQL support the REPLACE function, namely, MySQL 5.7, MySQL 5.6, MySQL 5.5, MySQL 5.1, MySQL 5.0, MySQL 4.1, MySQL 4.0 and MySQL 3.23. Syntax: REPLACE( string, from_substring, to_substring ) Parameters: string: It is … Read more