mysql date function code example

Example 1: date mysql

-- sintax of date type in mysql:
-- ' YYYY-MM-DD ' 
SELECT *
FROM table
WHERE date_to_find = '2020-05-25'

Example 2: mysql string function

MySQL String Functions
ASCII
SUBSTRING
ORD
MID
CONV
SUBSTRING_INDEX
BIN
LTRIM
OCT
RTRIM
HEX
TRIM
CHAR
SOUNDEX
CONCAT
SPACE
CONCAT_WS
REPLACE
LENGTH
REPEAT
CHAR_LENGTH
REVERSE
BIT_LENGTH
INSERT
LOCATE
ELT
INSTR
FIELD
LPAD
LCASE
RPAD
UCASE
LEFT
LOAD_FILE
RIGHT
QUOTE