title: MySQL replace multiple character
body: <p>I need to fetch data from my MySQL database where one column is filled with strings that contains different quotes and apostrophes (<em>‘, ’, ` and the classic one '</em>). </p>
  
  <p>In my search bar, I want to be able to only write the classic one ' and be able to search for that specific field wheter it contains ‘, ’ or `.
  For example, I'd like to write "<strong><em>Regie de l'Angleterre</em></strong>" and that it automatically checks "<strong><em>Regie de l‘Angleterre</em></strong>" and so on.</p>
  
  <p>Is that possible ?</p>
  
  <p>How can I do something like this in SQL ? I tried to use REPLACE, but couldn't make it work with multiple </p>
  
  <p>My where clause looks like this at the moment.</p>
  
  <pre><code>SELECT realestate_name FROM realestates WHERE REPLACE(realestate_name, ''','\'') LIKE %xxx%
  </code></pre>