Hello. I want to get some random results. Model.search :order => 'RAND()' produces => SELECT * FROM `table` WHERE `sphinx_deleted` = 0 ORDER BY *`* RAND()*`* LIMIT 0, 20 Which return error => ThinkingSphinx::SyntaxError: sphinxql: syntax error, unexpected $undefined, expecting IDENT (or 6 other tokens) near '`RAND()` LIMIT 0, 20; SHOW META'
Direct query without backquotes runs fine SELECT * FROM `table` WHERE `sphinx_deleted` = 0 ORDER BY RAND() LIMIT 0, 20 So how do I manage this? Or should I use riddle instead? (anyway, whould be nice to know if there is option to disable wrapping) -- You received this message because you are subscribed to the Google Groups "Thinking Sphinx" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/thinking-sphinx. For more options, visit https://groups.google.com/groups/opt_out.
