I'm trying to return the title of books that were published in August 2014. I'm not sure what's wrong.
SELECT title_name FROM titles WHERE pubdate = '2014-08%';
I know how to find titles of books between two different dates, so shouldn't the format be the same except the greater than or less than sign is replaced with equals?
SELECT title_name FROM titles WHERE pubdate > '2014-07-15' AND pubdate < '2014-08-15';