How to make a query with a string condition in the sphinx?

Question

Sphinx

SELECT * FROM `real_index` WHERE product_key = "adsadaddsasd" LIMIT 2'

gives an error syntax error, unexpected IDENT, expecting CONST_INT or CONST_FLOAT or '-' near
if you do product_key = 123123, everything is fine, that is, it requires a number in absolutely any request, even if you put some other field instead of product_key. for example title = "adsadaddsasd" and so on

Answer 1

solved the problem, installed a more recent version, and requests are executed correctly

Answer 2

You have a numeric key product, and there should be a match there