Mathz.nu
—
by
UPDATE `Smslog` SET`State`=7 WHERE RIGHT(‘2017-02-13’,Idate) AND State = 14
Simple regex Regex quick reference [abc] A single character: a, b or c [^abc] Any single character but a, b, or c [a-z] Any single character in the range a-z [a-zA-Z] Any single character in the range a-z or A-Z ^ Start of line $ End of line \A …