Built-In Function and Operator Reference Name Description Introduced Deprecated LineString() Construct LineString from Point values LN() Return the natural logarithm of the argument LOAD_FILE() Load the named file LOCALTIME() , LOCALTIME Synonym for NOW() LOCALTIMESTAMP , LOCALTIMESTAMP() Synonym for NOW() LOCATE() 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() Return the argument in lowercase LPAD() Return the string argument, left-padded with the specified string LTRIM() Remove leading spaces MAKE_SET() Return a set of comma- separated strings that have the corresponding bit in bits set MAKEDATE() Create a date from the year and day of year MAKETIME() Create time from hour, minute, second MASTER_POS_WAIT() Block until the replica has read and applied all updates up to the specified position MATCH Perform full-text search MAX() Return the maximum value MBRContains() Whether MBR of one geometry contains MBR of another MBRCoveredBy() Whether one MBR is covered by another 2105