Bring sql record even if you don’t have the necessary accent

Question

I need to bring a record called Vidraçaria in a survey, how can I bring this record by writing only Glassware in research?

Or bring water seeking only agua

The search works normally when the word is written correctly, with or without accent.

I’m using like() to fetch information in mysql records

Answer 1

Use a function to remove accents from the searched word and from what is in the bank. This way you will find the word with or without accents:

function tiraacentos($i){
   return preg_replace(array("/(á|à|ã|â|ä|Á|À|Ã|Â|Ä)/","/(é|è|ê|ë|É|È|Ê|Ë)/","/(í|ì|î|ï|Í|Ì|Î|Ï)/","/(ó|ò|õ|ô|ö|Ó|Ò|Õ|Ô|Ö)/","/(ú|ù|û|ü|Ú|Ù|Û|Ü)/","/(ñ|Ñ)/","/(ç|Ç)/","/(ý|ÿ|Ý)/"),explode(" ","a e i o u n c y"),$i);
}

In the query you use the function in the BD table name and the search term:

$palavra = $_POST['palavra'];
"SELECT * FROM tabela WHERE ".tiraacentos(NOME DA TABELA)." LIKE '%".tiraacentos($palavra)."%'"

Answer 2

You can use a collation different at runtime to remove accents:

...
WHERE nome like '%vidracaria%' collate utf8_general_ci

Or in case of pointed error:

...
WHERE nome like '%vidracaria%' collate utf8mb4_general_ci