-- create a table
CREATE TABLE mytable (
  id INTEGER PRIMARY KEY,
  date TEXT NOT NULL,
  vol TEXT NOT NULL
);
-- insert some values
INSERT INTO mytable VALUES ('1', '2004-02-01', 'First of february');
INSERT INTO mytable VALUES ('2', '2004-02-03', 'Other day');
INSERT INTO mytable VALUES ('3', '2004-02-05', 'Other day');
INSERT INTO mytable VALUES ('4', '2004-03-01', 'First of March');
INSERT INTO mytable VALUES ('5', '2004-03-04', 'Other day');
INSERT INTO mytable VALUES ('6', '2004-03-06', 'Other day');
INSERT INTO mytable VALUES ('7', '2004-04-01', 'First of April');
INSERT INTO mytable VALUES ('8', '2004-04-07', 'Other day');
INSERT INTO mytable VALUES ('9', '2004-04-08', 'Other day');
-- fetch some values
SELECT * FROM mytable WHERE date LIKE '____-__-01';