MYSQL SELECT statements : <p>I made a table and I want to select certain data from the table using select statements.
I want to see all the book titles that  were published in May.
How can I go about doing this?</p>

<p>Here is the table</p>

<pre><code>CREATE TABLE titles
  (
  title_id   CHAR(3)      NOT NULL,
  title_name VARCHAR(40)  NOT NULL,
  type       VARCHAR(10)          ,
  pub_id     CHAR(3)      NOT NULL,
  pages      INTEGER              ,
  price      DECIMAL(5,2)         ,
  sales      INTEGER              ,
  pubdate    DATE                 ,
  contract   SMALLINT     NOT NULL,
  CONSTRAINT pk_titles PRIMARY KEY (title_id)
  )ENGINE = InnoDB;
</code></pre>

<p>I tried this: </p>

<pre><code>SELECT * FROM titles
    WHERE pubdate LIKE '%%%%-05-%%';
</code></pre>

<p>It displays the whole column, how can I get it to only display the books title?</p>
