sql help please!

[tallberg]

Can some one please describe to me the difference between these 2 queries. The first one produces 9,658 rows and second on 314 rows. I don't know what the difference is.

SELECT *
FROM `plantsdb`
WHERE Colour_Foliage LIKE '%blue%'
OR Colour_Foliage LIKE '%green%'

SELECT *
FROM `plantsdb`
WHERE Colour_Foliage LIKE '%blue%'
OR '%green%'

[fenway]

The first query is correct... the second query is simply evaluating '%green%' as being true on some random field, having nothing to do with Colour_Foliage, and is returning garbage.