How can I set the condition for a spinks search? In my custom MySQL code, as follows:
How can I re-code it as a Spinks search?
  $ condition = "(in case related_type = 'course' THEN related_ id = 1 ELSE related_id IN (2, 3,4) END)"; << Code>    
  There is a  IF ()  function in SPINXQUL Used in the same fashion 
  For example: 
   SELECT *, IF (related_type = 'course', related_id = 1, IN (related_id, 2,3) , 4)) as filter from myindex where the filter = 1  
  should be in the  SELECT  section, not in  WHERE  
  (Note also a slightly different syntax for  IN .) This function is in Sphinx 
   
 
No comments:
Post a Comment