Built-In Function and Operator Reference Name Description Introduced Deprecated NOT ,  ! Negates value NOT BETWEEN ... AND ... Whether a value is not within a range of values 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() Return the current date and time NTH_VALUE() Value of argument from N-th row of window frame NTILE() Bucket number of current row within its partition. NULLIF() Return NULL if expr1 = expr2 OCT() Return a string containing octal representation of a number OCTET_LENGTH() Synonym for LENGTH() OR ,  || Logical OR ORD() Return character code for leftmost character of the argument PERCENT_RANK() Percentage rank value PERIOD_ADD() Add a period to a year- month PERIOD_DIFF() Return the number of months between periods PI() Return the value of pi Point() Construct Point from coordinates Polygon() Construct Polygon from LineString arguments POSITION() Synonym for LOCATE() POW() Return the argument raised to the specified power POWER() Return the argument raised to the specified power PS_CURRENT_THREAD_ID() Performance Schema thread ID for current thread 8.0.16 2107