ERROR 1054 Unknown Column 'Aust' in 'where clause'

[christL]

This is the QUERY that I'm having trouble with...

SELECT * FROM spa
WHERE MATCH Keywords AGAINST ('varRefine') AND spa.Region = varRegion2
ORDER BY spa.Spa Name

The error I get is:

Unknown column "Australia" in "where clause"

Why is Australia (varRegion2 value) being refered to as a column instead of just a value in the Region column ??

thanks in advance 4 any help,

christL

[sdjensen]

first replace all ` with '
second try printing the query before executing, 9 out of 10 times you can spot the mistake