Getting full text content from Sphinx search
So I am using the PHP api and have executed a successful Query(). I basically have an array of Ids. Do I just do:
SELECT * FROM mytable WHERE primary_id IN (5, 29, 52, 23, 59, 22) ORDER BY FIELD(primary_id, 5, 29, 52, 23, 59, 22);
Or is there a better way to get the resultset in the order Sphinx rated them?