Sphinx for text search only?

Question

Sphinx

They write that sphinx is designed for text search.
And if there are other fields with integer values ​​in the table and you need to search for all of them, then what to do: search by text value separately from sphinx and by integer from the database, the results will be different, then how to find the difference and remove the extra ones and leave the necessary ones - this is complete idiocy!? In general, tell me how such tasks are actually performed?

Answer 1

Any database for storage and retrieval.
Sphinx is no exception.
Let's say I use it to filter data.
The tokens in this case are the values ​​of the vectors.
But the advantage of Sphinx is when combining a huge number of answers.

Answer 2

In general, tell me how such tasks are actually performed?

"Waterfall slope": first we search by the most unique values ​​(numbers, articles, models), then - by all the rest.

Answer 3

There are faceted searches for attributes of any type