RIGHT() FUNCTION The MySQL RIGHT function is used to extract a substring from a string. It starts the extraction from the RIGHT-most character. The various versions of MySQL support the RIGHT 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: RIGHT( string, number_of_characters ) … Read more
LEFT() FUNCTION The MySQL LEFT function is used to extract a substring from a string. It starts the extraction from the left-most character. The various versions of MySQL support the LEFT 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: LEFT( string, number_of_characters ) … Read more
LOWER() FUNCTION The MySQL LOWER function is used to convert all characters in the specified string to lowercase. The various versions of MySQL support the LOWER 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: LOWER( string ) Parameters: string: It is used to … Read more
LCASE() FUNCTION The MySQL LCASE function is used to convert all characters in the specified string to lowercase. The various versions of MySQL support the LCASE 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: LCASE( string ) Parameters: string: It is used to … Read more
INSTR() FUNCTION The MySQL INSTR function is used to get the location of a substring in a string. The various versions of MySQL support the INSTR 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: INSTR( string, substring ) Parameters: string: It is used … Read more
INSERT() FUNCTION The MySQL INSERT function is used to insert a substring into a string. This insertion is done at a specified position and for a certain number of characters. The various versions of MySQL support the INSERT function, namely, MySQL 5.7, MySQL 5.6, MySQL 5.5, MySQL 5.1, MySQL 5.0, MySQL 4.1, MySQL 4.0 and … Read more
FORMAT() FUNCTION The MySQL FORMAT function is used to format a number as a format of ‘#,###.##’. It also rounds the number to a certain number of decimal places, as specified. The various versions of MySQL support the FORMAT function, namely, MySQL 5.7, MySQL 5.6, MySQL 5.5, MySQL 5.1, MySQL 5.0, MySQL 4.1, MySQL 4.0 … Read more
FIND_IN_SET() FUNCTION The MySQL FIND_IN_SET function is used to get the position of a string in a comma-delimited string list. The various versions of MySQL support the FIND_IN_SET 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: FIND_IN_SET( string, string_list ) Parameters: string: It … Read more
FIELD() FUNCTION The MySQL FIELD function is used to get the position of a value in a list of values. The various versions of MySQL support the FIELD 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: FIELD( value, val_1, val_2, … val_n ) … Read more
LENGTH() FUNCTION The MySQL LENGTH function is used to get the length of the specified string in bytes. The various versions of MySQL support the LENGTH 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: CHARACTER_LENGTH() FUNCTION in MySQL Parameters: string: It is used … Read more