How do I search "many LIKE" in the database (mysql)?

Question

I want to search number of strings in the Database (type: MYSQL) and I did this:

SELECT * 
  FROM `rooms` 
 WHERE `dates` LIKE '%09/08/10%' OR '%08/08/10%'

Why doesnt it work? when I removed the part of OR '%08/08/10%' it was working well, I think I use it not good. How should I do it?

Answer 1

SELECT ... 
FROM rooms 
WHERE dates LIKE '%09/08/10%' 
  Or dates LIKE '%08/08/10%'

Answer 2

Try like this:

SELECT * 
FROM rooms 
WHERE 
      dates LIKE '%09/08/10%' 
      OR 
      dates LIKE '%08/08/10%'