title: MySQL exact search for also foreign characters
body: <p>I have a MySQL database encoded in UTF-8 that contains English and Hungarian text.</p>
  
  <p>I'm working on a search function and the results are acceptable except one thing:</p>
  
  <p>The search on strings containing "á", "é", "í", "ó", "ö", "ő", "ú", "ü", "ű" results all the occurances of them but also shows the results for "a", "e", "i", "o", "u". This way the search won't be precise because it results a lot of unwanted records, for example, we get all the "bar" for "bár" (which are obviously not the same).</p>
  
  <p>I made the search by LIKE in a simply way (although it has many variations for whole-words-search-only or for exact word order, the base is the same):</p>
  
  <pre><code>SELECT * FROM table WHERE coloumn LIKE 'word'
  </code></pre>
  
  <p>How can I escape the unwanted results? I'm not an SQL expert and have never made a search like this, so I need a little help...</p>
  
  <p>Thanks!</p>