PHP-- select specific rows?

[gabriel gleezer]

I am trying to select all entires with a specific value. WHERE only works with Integers, but is there a way to get all the rows that have a text value?

SELECT * FROM 'mytable' WHERE color="yellow"