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.
SQL – MySQL RPAD() Function
The MySQL RPAD() function right-pads a string with another string, to achieve a specified length.
SQL – MySQL SECOND() Function
The MySQL SECOND() function returns the seconds part of a time/datetime (from 0 to 59).
SQL – MySQL SEC_TO_TIME() Function
The MySQL SEC_TO_TIME() function returns a time value (in format HH:MM:SS) based on the specified seconds (positive or negative).
SQL – MySQL SESSION_USER() Function
The MySQL SESSION_USER() function returns the current user name and host name for the MySQL connection.
SQL – MySQL SPACE() Function
The MySQL SPACE() function returns a string of the specified number of space characters.
SQL – MySQL SQRT() Function
The MySQL SQRT() function returns the square root of a number greater than zero.