The discussion here is very helpful, I would like to add something new I found:
prefix query will match the document, so you can query like this
since it will query the whole document(usually used by a document database, think it like a row, it means every field) , you can filter the result by the field of SKU again based on the result.
for the suffix part, I guess the search engine is implemented with elastic search, and since there are no efficient way to do suffix query by default, so it is not implemented yet.
help this helpful.
|an hour ago|