The information is a bit vague, so I can't see the table names, but something like:
Model.count(:conditions => ["answer LIKE %?%", searched_word]) Add more conditions to select answers for squares only Model.count(:conditions => ["answer LIKE %?% AND type='square'", searched_word]) (however this type information is stored) Depending on the actual structure of your models/database, additional includes may be necessary or you may have to fall back on plain SQL. In any case I would try to keep it in SQL for performance reasons, not let Ruby array functions count through lots of records. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---
