title: How to use LIKE query in Ruby on Rails
body: <p>LIKE query in mysql, queries the database and disregards case. 
  For example:</p>
  
  <pre><code>"bzupnick" = "Bzupnick" #  false
  "bzupnick" LIKE "Bzupnick" # true
  </code></pre>
  
  <p>So how does one do a LIKE query in Ruby on Rails. </p>
  
  <p>Here's an example query:</p>
  
  <pre><code>@results = User.joins(:jobs).where(:jobs =&gt; { :job_name =&gt; job }, :users =&gt; { :zip =&gt; zip })
  </code></pre>