What's wrong with this update query?

[vigour]

I'm trying a update query in phpMyAdmin. I don't understand why it does not work. It affect 0 rows, but I have over 500 that will match. The thing I'm trying to do is to set product to paint in every row where color begins with red.

UPDATE products SET product = 'paint' WHERE color = 'red%'

[NogDog]

UPDATE products SET product = 'paint' WHERE color [color=red]LIKE[/color] 'red%'