Excuse me??? I don't appreciate being shouted at.

I suggest changing the table definition because you're using a completely inappropriate data type for the column. The text data type is for really, really, really large strings, over 8000 characters and because it's designed for data of that size it can't be used in equality comparisons. So fix the cause of the problem, which is the really poor choice of data type, use a data type that's appropriate for 10-character long strings and you'll be able to do equality comparisons on it.