Escaping string using multiple strings

General Discussions - English
1

Hi,

I’m trying to do string escaping. When I do it using single field it works just fine.

For instance:
Using old Sphinx search engine query used to be: select * from ad_complete where match(‘@(name) \\=\\\“\\\”’)
Following manticore documentation query should be: select * from ad_complete where match(‘@(name) =\\“\\”’))

However, when I try to add another field matching another keyword, I get the error SQL Error [1064] [42000]: table ad_complete: P08: syntax error, unexpected TOK_FIELDLIMIT near ’ ="" @(description) test’.
The example of query is: select * from ad_complete where match(‘@(name) =\\“\\” @(description) test’).

Is there a way to get over this? I expect it to work just fine as with only one field. I’m covering cases when user inputs things like “”, :slight_smile: (any smiley chars that should be escaped) etc… in the search field but have some other default conditions than I’m passing to the match query.

Thanks

2

Hi.

Can you please escape your examples using triple backticks in your original message? :slight_smile:

What’s the unescaped text you want to look for in Manticore?