title: Grails SQL match criteria
body: <p>My case are searching people over interest types, age, activities and so on. And at least one information must match and show the result.
  For example: It must be a woman within 25-31 years old range and (optionally) I would like to know people that speak: english, german and italian, and my interests are: going to party, people that speak my language, do activities outside. Another profile create is almost the same with some information are equals.</p>
  
  <p>Age and sex are the main lock of matching the criteria. And others are optional, the example above, if a person speak japanese and italian and must be a woman within 25-31 years old, show in results.</p>
  
  <p>But I'm stuck where I want to find people that has speak any of 3 language, or interests, how can I loop through it(I have an array)? Should I get all results and then make a method the compare? Or should I use <code>createCriteria()</code>
  My code is static: </p>
  
  <pre><code>def e = User.executeQuery("from User as u where (u.profile.sexType = 2 and u.profile.ageRangeType = 2) &gt; (select Profile as p where ")
  </code></pre>
  
  <p>My english is not the best.</p>