In fact, he began to deal with the Sphinx. Staged, configured, and built the index. Made the search ("find->word").
And that's what I do not understand - whether the Sphinx in the search results give all the fields?
Let's say I set
sql_query = SELECT id,name,surname FROM test;
And looking at the part of the word "You." How do I get another id in addition to name and surname? Logic dictates that if I can find all "You"<b>, the index stores and the name and surname, so why should I once again ask the database about their names by ID, if I can get them from sphinx. It is not clear.
PS: I Admit that it's very simple, but a quick search on documentation not natolknuli me a bright idea.