Hi,

Im new to this MySQL. Im trying the following query on a table called music with 2 columns called artist and type.

SELECT *
FROM music
WHERE artist = Metallica
LIMIT 0 , 30

MySQL said:

#1054 - Unknown column 'Metallica' in 'where clause'

Ive tried messing around with it but am pretty mush losing. Any help would be greatly appreciated.

Cheers .

in the context of your query the way you wrote it, Metallica is a column, whereas 'Metallica' is a string value, which is what you want

Yes thats it. Cheers, was a rather n00bish question.

Thanks

Jon