[RESOLVED] Where clause and Characters

I am new to Mysql and PHP and wanted a answer to a very simple problem.

In a Where clause clause are characters supported?

For example "SELECT * FROM database WHERE Channel = TWO

The reason I asked this is I get an error if I use this query but if run the exact same query but change it slightly to this.

"SELECT * FROM database WHERE Channel = 2

This work without any errors.

No need to reply,
I have worked it out.
Basically I needed to add a single quotation mark to around the sting of characters.
That did the trick

The solution you found is correct; MySQL syntax when dealing with strings is similar to PHP - in both languages, strings must be delimited by quotes.

Don't forget to mark this thread resolved using the link on the Thread Tools menu.