Home

Field Values and Functions

Type	INSERT		WHERE
	Sample	Result	Sample	Result
String	field: 'value'	`field` = 'value'	{field: 'value'}	(`field` = 'value')
Number	field: 1	`field` = 1	{field: 1}	(`field` = 1)
NULL	field: null	`field` = NULL	{field: null}	ISNULL(field)
Date	field: new Date()	`field` = '1979-06-03 01:23:45'	{field: new Date()}	(`field` = '1979-06-03 01:23:45')
Date: $NOW	field: '$NOW'	`field` = '1979-06-03 01:23:45'	{field: '$NOW'}	(`field` = '1979-06-03 01:23:45')
Date: $DATE	field: {$DATE: new Date()}	`field` = '1979-06-03'	{field: {$DATE: new Date()}}	(`field` = '1979-06-03')
Date: $TIME	field: {$TIME: new Date()}	`field` = '01:23:45'	{field: {$TIME: new Date()}}	(`field` = '01:23:45')
Date: $YEAR	field: {$YEAR: new Date()}	`field` = 1979	{field: {$YEAR: new Date()}}	(`field` = 1979)
Date: $TIMESTAMP	field: {$TIMESTAMP: new Date()}	`field` = 297221025	{field: {$TIMESTAMP: new Date()}}	(`field` = 297221025)
Array	field: [1, 2]	`field` = '{\"0\":1,\"1\":2}'	{field: [1, 2]}	(`field` = '{\"0\":1,\"1\":2}')
Object	field: {a: 'b',c: 'd'}	`field` = '{\"a\":\"b\",\"c\":\"d\"}'	{field: {a: 'b',c: 'd'}}	(`field` = '{\"a\":\"b\",\"c\":\"d\"}')

SELECT functions

• DISTINCT
• SUM
• AVG
• MAX
• MIN
• COUNT
• ASCII
• BIN
• OCT
• ORD
• HEX
• UNHEX
• BIT_LENGTH
• TO_BASE64
• FROM_BASE64
• DATE
• TIME
• YEAR
• MONTH
• MONTHNAME
• WEEK
• DAYOFYEAR
• DAYOFMONTH
• DAYOFWEEK
• HOUR
• MINUTE
• SECOND
• UNIX_TIMESTAMP
• LENGTH
• LCASE
• LOWER
• LTRIM
• RTRIM
• SPACE
• TRIM
• UCASE
• UPPER
• REVERSE
• CONCAT
• FORMAT
• INSTR
• LEFT
• REPLACE
• LPAD
• RPAD
• SUBSTR
• SUBSTRING
• DATE_FORMAT

WHERE / HAVING conditions

• : (equal)
• NOT
• EQ (equal with value function)
• NE (not equal)
• BETWEEN
• IN
• LIKE
• LLIKE (like at the end of string)
• RLIKE (like at the beginning of string)
• LT (less than)
• LTE (less than or equal)
• GT (greater than)
• GTE (greater than or equal)