# Combine sql with ferret

**URL:** <https://www.ruby-forum.com/t/combine-sql-with-ferret/125972>\
**Category:** Rails\
**Created:** [January 14, 2008, 10:38am UTC](https://www.ruby-forum.com/t/combine-sql-with-ferret/125972 "2008-01-14T10:38:09Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Sylvain](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/s/7ba0ec/32.png) [@Sylvain](https://www.ruby-forum.com/u/Sylvain)\
**Post date:** [January 14, 2008, 10:38am UTC](https://www.ruby-forum.com/t/combine-sql-with-ferret/125972/1 "2008-01-14T10:38:09Z")

</div>

Dear all,  
Ferret seems to be great for full text searches and mysql is  
suitable for relational searches. Now, what is the most efficient way  
to combine both in a ruby on rails application? For instance, I would  
like to retrieve all entries matching a lucene query AND a mysql  
query.  
Thank you for your help,  
Sylvain

---

<div class="post-metadata">

**Author:** ![Sylvain](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/s/7ba0ec/32.png) [@Sylvain](https://www.ruby-forum.com/u/Sylvain)\
**Post date:** [January 15, 2008, 7:32pm UTC](https://www.ruby-forum.com/t/combine-sql-with-ferret/125972/2 "2008-01-15T19:32:22Z")

</div>

No way to combinate directly i think.

But you can make one as a filter to another one.