Unknown column in 'where clause'

[PeterPan]

Hello.

I've used MYSQL a bit - but no expert. I'm getting a confusing error..

PHP :-

SELECT * FROM `Worksheet` WHERE `Group_ID` = test;

Error :-

ERROR -
Unknown column 'test' in 'where clause'

Now, i am NOT looking for a column named test - i want to see if 'test' is somewhere in the column Group_ID.

Can anyone advise where I am going on, & why is it treating a value like a column/field name.

EDIT :- I AM expecting 0 / zero results at this time, so i want to retrieve some useful response if its 0 results (or nore than 0 )

Later on, there will be 1 or more results

[entrecon]

I think it is in your quotes. Here is a sample I found:

SELECT * FROM Persons WHERE FirstName='Peter';

So, yours would read:

SELECT * FROM Worksheet WHERE Group_ID='test';