CREATE TABLE myTable
(`id`
int auto_increment primary key
, `
time` date_time
);INSERT INTO myTable
(`
time`
) VALUES
('2014-01-01 11:12:13');INSERT INTO myTable
(`
time`
) VALUES
('2014-01-11 21:12:13');INSERT INTO myTable
(`
time`
) VALUES
('2014-03-11 21:12:13');SELECT
* FROM myTable WHERE `
time` LIKE
'2014-01%';
Q1JFQVRFIFRBQkxFIG15VGFibGUgKGBpZGAgaW50IGF1dG9faW5jcmVtZW50IHByaW1hcnkga2V5LCBgdGltZWAgZGF0ZV90aW1lKTsKSU5TRVJUIElOVE8gbXlUYWJsZSAoYHRpbWVgKSBWQUxVRVMgKCcyMDE0LTAxLTAxIDExOjEyOjEzJyk7CklOU0VSVCBJTlRPIG15VGFibGUgKGB0aW1lYCkgVkFMVUVTICgnMjAxNC0wMS0xMSAyMToxMjoxMycpOwpJTlNFUlQgSU5UTyBteVRhYmxlIChgdGltZWApIFZBTFVFUyAoJzIwMTQtMDMtMTEgMjE6MTI6MTMnKTsKU0VMRUNUICogRlJPTSBteVRhYmxlIFdIRVJFIGB0aW1lYCBMSUtFICcyMDE0LTAxJSc7