SQL – MySQL DAYOFWEEK() Function
The MySQL DAYOFWEEK() function returns the weekday index for a given date (a number from 1 – Sunday to 7 – Saturday).
SQL – MySQL DAYOFYEAR() Function
The MySQL DAYOFYEAR() function returns the day of the year for a given date (a number from 1 to 366).
SQL – MySQL EXP() Function
The MySQL EXP() function returns the natural logarithm e (2.718281…) raised to the power of the specified number.
SQL – MySQL FIELD() Function
The MySQL FIELD() function returns the index position of a case-insensitive value in a list of values.
SQL – MySQL FIND_IN_SET() Function
The MySQL FIND_IN_SET() function returns the position of a string within a list of strings.
SQL – MySQL FLOOR() Function
The MySQL FLOOR() function returns the largest integer value that is smaller than or equal to a number.
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.