CONTAINS CLAUSE PROBLEM (PHP Version 5.2.10)

Hi guys,

I am not sure whats wrong with this CONTAINS clause.

EXAMPLE -
TABLE NAME scores

**FIELDS -> VALUES **
UserName -> amep
VALUE -> 12

UserName -> b221
VALUE -> 10

I am executing these queries and it is giving me an empty result set :
SELECT * from scores WHERE CONTAINS(UserName, ‘am’);
OR
SELECT * from scores WHERE CONTAINS(‘UserName’, ‘am’);
OR
SELECT * from scores WHERE CONTAINS(‘UserName’, ‘“am”’);
OR
SELECT * from scores WHERE CONTAINS(‘UserName’, ‘am*’);

Shouldn’t this give me a row which has UserName = “amep” …Could somebody figure out whats wrong with these queries?

Thanks.