How to bypass an accent in mysql + Php

Question

I have in my database words with accents and when I want to call I use this SQL below.

But if a word in the database has accent I need to also use the word accented in my search, otherwise nothing returns.

How do I get around that situation and research both accented and accented words?

 SELECT * FROM produtos WHERE status_pr='online' AND (LCASE(nome_pr) LIKE '%$get%' 
 OR LCASE(descricao_pr) LIKE '%$get%' OR LCASE(marca_pr) LIKE '%$get%'
 OR LCASE(linha_pr) LIKE '%$get%' OR LCASE(categoria_pr) LIKE '%$get%')

In the code above, $get is the PHP variable that will be searched for.

Answer 1

Copying Based on that response from the OS, you just have to select the fields using utf8 as charset:

SELECT * FROM produtos WHERE status_pr='online' AND (LCASE(nome_pr) LIKE _utf8'%$get%' 
 OR LCASE(descricao_pr) LIKE _utf8'%$get%' OR LCASE(marca_pr) LIKE _utf8'%$get%'
 OR LCASE(linha_pr) LIKE _utf8'%$get%' OR LCASE(categoria_pr) LIKE _utf8'%$get%')

Answer 2

Try to do so:

SELECT *
  FROM `produtos`
  WHERE status_pr='online' AND nome_pr LIKE _utf8 'SAO PAULO' COLLATE utf8_unicode_ci 

more information -> http://www.dicas-l.com.br/arquivo/consultas_case-insensitive_no_postgresql_e_no_mysql.php#. Vi7iiyvf_ay

Answer 3

https://stackoverflow.com/questions/3304464/mysql-diacritic-insensitive-search-spanish-accents/3304596#3304596

Based on this question I found an answer that talks about the
SELECT CONVERT(column_name USING utf8) FROM table_name LIKE '%giga%'
that solved my problem, this can help others. Thank you Thomas