Status field couldnt fetch

Question

Using SphinxQl, I could not fetch status fields from particular index. If I try to fetch the status fields, I will get following errors. Please any one help to solve that issue?

Example:

Select Status from tablename;

I got following error:

syntax error, unexpected STATUS, expecting IDENT (or 17 other tokens) near 'Status from tablename'.

Note: I could not insert any value at STATUS field in any index.

score 0 · Answer 1 · answered Aug 02 '12 at 21:19

0

STATUS is a reserved word , use `status`

answered Aug 02 '12 at 21:19

aditirex

692
3
12

Thanks its working .. Let me know what are the reservered words there in sphinxQL ? – karthik Aug 03 '12 at 05:03

Status field couldnt fetch

1 Answers1