SQL – MySQL FORMAT() Function
The MySQL FORMAT() function formats a number to a format like “#,###,###.##”, rounded to a specified number of decimal places, and returns it as a string.
SQL – MySQL FROM_DAYS() Function
The MySQL FROM_DAYS() function returns a date from a numeric datevalue.
SQL – MySQL GREATEST() Function
The MySQL GREATEST() function returns the greatest value of the list of arguments.
SQL – MySQL HOUR() Function
The MySQL HOUR() function returns the hour part for a given date (from 0 to 838).
SQL – MySQL IF() Function
The MySQL IF() function returns a value if a condition is TRUE, or another value if a condition is FALSE.
SQL – MySQL IFNULL() Function
The MySQL IFNULL() function returns a specified value if the expression is NULL.
SQL – MySQL INSERT() Function
The MySQL INSERT() function inserts a string within a string at the specified position and for a certain number of characters.
SQL – MySQL INSTR() Function
The MySQL INSTR() function returns the position of the first occurrence of a case-insensitive string in another string.
SQL – MySQL ISNULL() Function
The MySQL ISNULL() function returns 1 (null) or 0 (not null) depending on whether an expression is NULL.
SQL – MySQL LAST_INSERT_ID() Function
The MySQL LAST_INSERT_ID() function returns the AUTO_INCREMENT id of the last row that has been inserted or updated in a table.
SQL – MySQL LAST_DAY() Function
The MySQL LAST_DAY() function extracts the last day of the month for a given date.
SQL – MySQL LEAST() Function
The MySQL LEAST() function returns the smallest value of the list of arguments.
SQL – MySQL LEFT() Function
The MySQL LEFT() function extracts a number of characters from a string, starting from left.
SQL – MySQL LN() Function
The MySQL LN() function returns the natural logarithm of a number (greater than 0).
SQL – MySQL LOCALTIME() Function
The MySQL LOCALTIME() function returns the current date and time as “YYYY-MM-DD HH-MM-SS” (string) or as YYYYMMDDHHMMSS.uuuuuu (numeric).
SQL – MySQL LOCALTIMESTAMP() Function
The MySQL LOCALTIMESTAMP() function returns the current date and time as “YYYY-MM-DD HH-MM-SS” (string) or as YYYYMMDDHHMMSS.uuuuuu (numeric).
SQL – MySQL LOCATE() Function
The MySQL LOCATE() function returns the position of the first occurrence of a case-insensitive substring in a string.
SQL – MySQL LOG() Function
The MySQL LOG() function returns the natural logarithm of a specified number, or the logarithm of the number to the specified base.