Home > Forum Webmaster > Getting full text content from Sphinx search

Getting full text content from Sphinx search

November 30th, 2010

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?


Click here for more…

No tags for this post.

Forum Webmaster

  1. No comments yet.
  1. No trackbacks yet.