title: Mysql select on word (plural, singular)
body: <p>In my Mysql DB I have a list of terms like (With First letters Capital and most of the time plurals)</p>
  
  <pre><code>Hairdressers
  Restaurants
  Beauty Salons 
  Fournitures For Restaurants
  </code></pre>
  
  <p>On my website I have a searchbar where the user can search for those word (my website is a kind of POI finder). But I'm having problems with my query. </p>
  
  <pre><code>SELECT * FROM TABLE WHERE word = 'userword'
  </code></pre>
  
  <p>1: If the user enter restaurants, it doesn't work because he put 'r' on lower case.
  2: if the user enter restaurant either because because he didn't put it in plural</p>
  
  <p>I have tried with <code>SELECT * FROM TABLE WHERE word like 'userword'</code></p>
  
  <p>This fix the problem for the Capital leters, but I have no idea how to make the query work when the user enter the word in singular. is the only solution add that word in DB as well ? </p>
  
  <p>Thank you</p>