I wanted to see if there is any way to search within a document so that it does not take into account the accents of the word. That is, if I want to search for the word "truck" in the text, I can do it by typing "truck" in the search window.
example I have this part of my PHP code Code:
SELECT * FROM anuncio WHERE tipo like '%".$busqueda."%';
If I look for "Food", "measure", "omi" .... everything works perfect, but if I look for "food" with C minuscule does not detect, how can I make the query to throw it to me, regardless of whether they are uppercase? lowercase or accents? thanks !!