Ver originalSELECT * FROM tabla WHERE MONTH(STR_TO_DATE(campofecha, '%d/%m/%Y')) = 1;
Ver originalSELECT * FROM tabla WHERE MID(campofecha, 4, 2)='01'