SQL – MySQL LCASE() Function
The MySQL LCASE() function converts a string to lower-case.
SQL – MySQL LEAST() Function
The MySQL LEAST() function returns the smallest value of the list of arguments.
SQL – MySQL LEFT() Function
The MySQL LEFT() function extracts a number of characters from a string, starting from left.
SQL – MySQL LN() Function
The MySQL LN() function returns the natural logarithm of a number (greater than 0).
SQL – MySQL LOCALTIME() Function
The MySQL LOCALTIME() function returns the current date and time as “YYYY-MM-DD HH-MM-SS” (string) or as YYYYMMDDHHMMSS.uuuuuu (numeric).
SQL – MySQL LOCALTIMESTAMP() Function
The MySQL LOCALTIMESTAMP() function returns the current date and time as “YYYY-MM-DD HH-MM-SS” (string) or as YYYYMMDDHHMMSS.uuuuuu (numeric).
SQL – MySQL LOCATE() Function
The MySQL LOCATE() function returns the position of the first occurrence of a case-insensitive substring in a string.
SQL – MySQL LOG() Function
The MySQL LOG() function returns the natural logarithm of a specified number, or the logarithm of the number to the specified base.
SQL – MySQL LOG2() Function
The MySQL LOG2() function returns the natural logarithm of a number greater than 0 to base 2.
SQL – MySQL LOG10() Function
The MySQL LOG10() function returns the natural logarithm of a number greater than 0 to base 10.
SQL – MySQL LPAD() Function
The MySQL LPAD() function left-pads a string with another string, to achieve a specified length.
SQL – MySQL MAKEDATE() Function
The MySQL MAKEDATE() function creates and returns a date based on a year and a number of days value.
SQL – MySQL MAKETIME() Function
The MySQL MAKETIME() function creates and returns a time based on an hour, minute, and second value.
SQL – MySQL MICROSECOND() Function
The MySQL MICROSECOND() function returns the microsecond part of a time/datetime (from 0 to 999999).
SQL – MySQL MINUTE() Function
The MySQL MINUTE() function returns the minute part of a time/datetime (from 0 to 59).