title: Accents insensitive search in MySql
body: <p>I have a database named: <code>Movies</code> whit colation <code>utf8_spanish_ci</code></p>
  
  <p>inside is the table <code>peliculas</code> whit collation <code>utf8_spanish2_ci</code></p>
  
  <p>inside the field <code>nombre</code> whit collation <code>utf8_spanish2_ci</code>too.</p>
  
  <p>The data in field name whit accents saves like this:</p>
  
  <pre><code>La CacerÃ­a    // La cacería
  El cÃ­rculo    // El círculo
  </code></pre>
  
  <p>actually I Use the query: <code>SELECT * FROM peliculas WHERE nombre like '%$string%'</code> but if I search without accent does not yield any results.</p>
  
  <p>So</p>
  
  <p>The query search and results should be:</p>
  
  <pre><code>|query    | Result |
  |------------------|
  |circulo  | cÃ­rculo|
  |caceria  | CacerÃ­a|
   ------------------
  </code></pre>
  
  <p>Any Idea is welcome</p>