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.