title: MySQL - Search the database by text string with special characters
body: <p>I have a news system, and we need you to access the details of the news from a link that will take the title of the news, not the news ID database.</p>
  
  <p><strong>Note:</strong> Some published news have words and letters with special characters, for example:</p>
  
  <p><strong>News title:</strong> <code>$title = Nuevo demo de la canción de ñandú;</code> </p>
  
  <p>This title explode with PHP to remove hyphens and spaces would be as follows.</p>
  
  <p><strong>Explode title:</strong> <code>$title_explode = explode(' ','-', $title);</code></p>
  
  <p><strong>Looks like this:</strong> <code>$title_filter = nuevo-demo-de-la-canción-de-ñandú;</code></p>
  
  <p>I created in the database a field <strong>title</strong> in this field the <code>$title</code> will be saved, and I have another field within the database, <strong>title_filter</strong>, where would place the title <code>$title_filter</code>, which it is the title that exploit, and would be saved also in the database, but we have a <strong>ñ</strong> and accented letters as we can to query the database to bring me to this record smoothly comparison.</p>
  
  <p><strong>Query:</strong> <code>$sql = SELECT * FROM news  WHERE title = $title_filter;</code></p>
  
  <p><strong>Domain with the news:</strong> www.dominio.com/nuevo-demo-de-la-canción-de-ñandú</p>
  
  <p><strong>My questions:</strong> </p>
  
  <ol>
  <li>This search is effective?</li>
  <li>You can optimize and remove accents $ title to make it so: <code>$title_filter = nuevo-demo-de-la-cancion-de-nandu;</code></li>
  <li>Worth create the additional field of the database <strong>title_filter</strong> to saved clean and do the title search on that title.</li>
  </ol>
  
  <p><strong>Note:</strong> The idea of not using the word ID to search the database is to have cleaner seo links and improve the website.</p>
  
  <p>I hope you have understood me and can help me solve this dilemma and make database query data more effective.</p>