Like operator into not full text field


#1

Hi

I’m moving from sphinxsearch to manticoresearch and I’m looking for an operator/condition that permit me a like function for “not full-text fields” in sphinxsearch I could obtain this in this way:
field_name = ‘*portionofword’
Is it possible obtain something like that?


#2

On string attributes only equality comparison can be performed. You could define this attributes as fulltext field and do the wildcard inside MATCH clause.