SQL – MySQL MID() Function
The MySQL MID() function extracts a substring from a string, starting at any position from the beginning or end of the string.
SQL – MySQL MOD() Function
The MySQL MOD() function returns the remainder of a number divided by another number.
SQL – MySQL MONTH() Function
The MySQL MONTH() function returns the month part for a given date (a number from 1 to 12).
SQL – MySQL MONTHNAME() Function
The MySQL MONTHNAME() function returns the name of the month for a given date.
SQL – MySQL NOW() Function
The MySQL NOW() function returns the current date and time as “YYYY-MM-DD HH:MM:SS” (string) or as YYYYMMDDHHMMSS.uuuuuu (numeric).
SQL – MySQL NULLIF() Function
The MySQL NULLIF() function compares two expressions and returns NULL if they are equal. Otherwise, the first expression is returned.
SQL – MySQL PERIOD_ADD() Function
The MySQL PERIOD_ADD() function adds a specified number of months to a period and will return the result formatted as YYYYMM.
SQL – MySQL PERIOD_DIFF() Function
The MySQL PERIOD_DIFF() function returns the difference between two periods (both periods should be in the same format). The result will be in months.
SQL – MySQL POSITION() Function
The MySQL POSITION() function returns the position of the first occurrence of a case-insensitive substring in a string.
SQL – MySQL POW() Function
The MySQL POW() function returns the value of a number raised to the power of another number.
SQL – MySQL POWER() Function
The MySQL POWER() function returns the value of a number raised to the power of another number.
SQL – MySQL QUARTER() Function
The MySQL QUARTER() function returns the quarter of the year for a given date value (a number from 1 to 4).
SQL – MySQL RADIANS() Function
The MySQL RADIANS() function converts a degree value (expressed as a positive or negative number) into radians.
SQL – MySQL RAND() Function
The MySQL RAND() function returns a random number between 0 (inclusive) and 1 (exclusive).
SQL – MySQL REPEAT() Function
The MySQL REPEAT() function repeats a string as many times as specified.
SQL – MySQL REPLACE() Function
The MySQL REPLACE() function replaces all case-sensitive occurrences of a substring within a string, with a new substring.
SQL – MySQL REVERSE() Function
The MySQL REVERSE() function reverses a string and returns the result.
SQL – MySQL RIGHT() Function
The MySQL RIGHT() function extracts a number of characters from a string, starting from right.
SQL – MySQL ROUND() Function
The MySQL ROUND() function rounds a number to a specified number of decimal places.