>
Greater than operator
1/183
| Term | Definition |
|---|---|
> | Greater than operator |
>> | Right shift |
>= | Greater than or equal operator |
< | Less than operator |
<>, != | Not equal operator |
<< | Left shift |
<= | Less than or equal operator |
<=> | NULL-safe equal to operator |
%, MOD | Modulo operator |
* | Multiplication operator |
+ | Addition operator |
- | Minus operator |
- | Change the sign of the argument |
/ | Division operator |
:= | Assign a value |
= | Assign a value (as part of a SET statement, or as part of the SET clause in an UPDATE statement) |
= | Equal operator |
ABS() | Return the absolute value |
ADDDATE() | Add time values (intervals) to a date value |
ADDTIME() | Add time |
AND, && | Logical AND |
ANY_VALUE() | Suppress ONLY_FULL_GROUP_BY value rejection |
ASCII() | Return numeric value of left-most character |
AVG() | Return the average value of the argument |
BETWEEN ... AND ... | Whether a value is within a range of values |
BIN() | Return a string containing binary representation of a number |
BINARY | Cast a string to a binary string |
CASE | Case operator |
CAST() | Cast a value as a certain type |
CEIL() | Return the smallest integer value not less than the argument |
CEILING() | Return the smallest integer value not less than the argument |
CHAR() | Return the character for each integer passed |
CHAR_LENGTH(), CHARACTER_LENGTH() | Return number of characters in argument |
CHARSET() | Return the character set of the argument |
COMPRESS() | Return result as a binary string |
CONCAT() | Return concatenated string |
CONV() | Convert numbers between different number bases |
CONVERT() | Cast a value as a certain type |
COUNT() | Return a count of the number of rows returned |
COUNT(DISTINCT) | Return the count of a number of different values |
CUME_DIST() | Cumulative distribution value |
CURDATE(), CURRENT_DATE(), CURRENT_DATE | Return the current date |
CURTIME(), CURRENT_TIME(), CURRENT_TIME | Return the current time |
DATE() | Extract the date part of a date or datetime expression |
DATE_ADD() | Add time values (intervals) to a date value |
DATE_FORMAT() | Format date as specified |
DATE_SUB() | Subtract a time value (interval) from a date |
DATEDIFF() | Subtract two dates |
DAYNAME() | Return the name of the weekday |
DAYOFMONTH(), DAY() | Return the day of the month (0-31) |
DAYOFWEEK() | Return the weekday index of the argument |
DAYOFYEAR() | Return the day of the year (1-366) |
DEFAULT() | Return the default value for a table column |
DIV | Integer division |
ELT() | Return string at index number |
EXISTS() | Whether the result of a query contains any rows |
EXP() | Raise to the power of |
EXTRACT() | Extract part of a date |
FIELD() | Index (position) of first argument in subsequent arguments |
FIND_IN_SET() | Index (position) of first argument within second argument |
FIRST_VALUE() | Value of argument from first row of window frame |
FLOOR() | Return the largest integer value not greater than the argument |
FORMAT() | Return a number formatted to specified number of decimal places |
FORMAT_BYTES() | Convert byte count to value with units |
FORMAT_PICO_TIME() | Convert time in picoseconds to value with units |
FOUND_ROWS() | For a SELECT with a LIMIT clause, the number of rows that would be returned were there no LIMIT clause |
FROM_BASE64() | Decode base64 encoded string and return result |
FROM_DAYS() | Convert a day number to a date |
FROM_UNIXTIME() | Format Unix timestamp as a date |
GET_FORMAT() | Return a date format string |
GREATEST() | Return the largest argument |
GROUP_CONCAT() | Return a concatenated string |
HEX() | Hexadecimal representation of decimal or string value |
HOUR() | Extract the hour |
IF() | If/else construct |
IFNULL() | Null if/else construct |
IN() | Whether a value is within a set of values |
INSERT() | Insert substring at specified position up to specified number of characters |
INSTR() | Return the index of the first occurrence of substring |
INTERVAL() | Return the index of the argument that is less than the first argument |
IS | Test a value against a boolean |
IS NOT | Test a value against a boolean |
IS NOT NULL | NOT NULL value test |
IS NULL | NULL value test |
ISNULL() | Test whether the argument is NULL |
LAST_DAY | Return the last day of the month for the argument |
LAST_VALUE() | Value of argument from last row of window frame |
LEAD() | Value of argument from row leading current row within partition |
LEAST() | Return the smallest argument |
LEFT() | Return the leftmost number of characters as specified |
LENGTH() | Return the length of a string in bytes |
LIKE | Simple pattern matching |
LN() | Return the natural logarithm of the argument |
LOCATE(), POSITION() | Return the position of the first occurrence of substring |
LOG() | Return the natural logarithm of the first argument |
LOG10() | Return the base-10 logarithm of the argument |
LOG2() | Return the base-2 logarithm of the argument |
LOWER(), LCASE() | Return the argument in lowercase |
LPAD() | Return the string argument, left-padded with the specified string |
LTRIM() | Remove leading spaces |
MAKEDATE() | Create a date from the year and day of year |
MAKETIME() | Create time from hour, minute, second |
MATCH() | Perform full-text search |
MAX() | Return the maximum value |
MICROSECOND() | Return the microseconds from argument |
MID() | Return a substring starting from the specified position |
MIN() | Return the minimum value |
MINUTE() | Return the minute from the argument |
MOD() | Return the remainder |
MONTH() | Return the month from the date passed |
MONTHNAME() | Return the name of the month |
NOT, ! | Negates value |
NOT BETWEEN ... AND ... | Whether a value is not within a range of values |
NOT EXISTS() | Whether the result of a query contains no rows |
NOT IN() | Whether a value is not within a set of values |
NOT LIKE | Negation of simple pattern matching |
NOT REGEXP | Negation of REGEXP |
NOW(), CURRENT_TIMESTAMP(), LOCALTIME() | Return the current date and time |
NULLIF() | Return NULL if expr1 = expr2 |
OCT() | Return a string containing octal representation of a number |
OR, || | Logical OR |
PERIOD_ADD() | Add a period to a year-month |
PERIOD_DIFF() | Return the number of months between periods |
PI() | Return the value of pi |
POW() | Return the argument raised to the specified power |
POWER() | Return the argument raised to the specified power |
QUARTER() | Return the quarter from a date argument |
RAND() | Return a random floating-point value |
REGEXP | Whether string matches regular expression |
REGEXP_INSTR() | Starting index of substring matching regular expression |
REGEXP_LIKE() | Whether string matches regular expression |
REGEXP_REPLACE() | Replace substrings matching regular expression |
REGEXP_SUBSTR() | Return substring matching regular expression |
REPEAT() | Repeat a string the specified number of times |
REPLACE() | Replace occurrences of a specified string |
REVERSE() | Reverse the characters in a string |
RIGHT() | Return the specified rightmost number of characters |
RLIKE | Whether string matches regular expression |
ROUND() | Round the argument |
ROW_COUNT() | The number of rows updated |
ROW_NUMBER() | Number of current row within its partition |
RPAD() | Append string the specified number of times |
RTRIM() | Remove trailing spaces |
SEC_TO_TIME() | Converts seconds to 'hh:mm:ss' format |
SECOND() | Return the second (0-59) |
SPACE() | Return a string of the specified number of spaces |
SQRT() | Return the square root of the argument |
STR_TO_DATE() | Convert a string to a date |
STRCMP() | Compare two strings |
SUBDATE() | Synonym for DATE_SUB() when invoked with three arguments |
SUBSTR() | Return the substring as specified |
SUBSTRING() | Return the substring as specified |
SUBSTRING_INDEX() | Return a substring from a string before the specified number of occurrences of the delimiter |
SUBTIME() | Subtract times |
SUM() | Return the sum |
SYSDATE() | Return the time at which the function executes |
TIME() | Extract the time portion of the expression passed |
TIME_FORMAT() | Format as time |
TIME_TO_SEC() | Return the argument converted to seconds |
TIMEDIFF() | Subtract time |
TIMESTAMP() | With a single argument, this function returns the date or datetime expression; with two arguments, the sum of the arguments |
TIMESTAMPADD() | Add an interval to a datetime expression |
TIMESTAMPDIFF() | Return the difference of two datetime expressions, using the units specified |
TO_BASE64() | Return the argument converted to a base-64 string |
TO_DAYS() | Return the date argument converted to days |
TO_SECONDS() | Return the date or datetime argument converted to seconds since Year 0 |
TRIM() | Remove leading and trailing spaces |
TRUNCATE() | Truncate to specified number of decimal places |
UPPER(), UCASE() | Convert to uppercase |
UTC_DATE() | Return the current UTC date |
UTC_TIME() | Return the current UTC time |
UTC_TIMESTAMP() | Return the current UTC date and time |
VALUES() | Define the values to be used during an INSERT |
VAR_POP() | Return the population standard variance |
VAR_SAMP() | Return the sample variance |
VARIANCE() | Return the population standard variance |
WEEK() | Return the week number |
WEEKDAY() | Return the weekday index |
WEEKOFYEAR() | Return the calendar week of the date (1-53) |
WEIGHT_STRING() | Return the weight string for a string |
XOR | Logical XOR |
YEAR() | Return the year |
YEARWEEK() | Return the year and week |