Sql of default search per phpmyadmin string

Question

Navigation

#1 by (0 votes)

2

I need to get the same result from a table search that returns the same portion of string and disregards the graphical accent of the search.

php mysql

asked by anonymous 20.04.2018 / 17:31

1 answer

Pick up the image of a Json Copying files without congesting the network

score 0 · Accepted Answer

Hello, one possible solution is you execute a SQL to fetch the data you want, so go to the phpmyadmin SQL tab and execute the following query:

SELECT * from nome_da_tabela WHERE content like '%texto_vai_aqui_%';

Replace the fields:

"table_name": by the name of the table where the data you want to fetch is; "texto_vai_here": text you want to search for;

For accentuation it redraws the collation to utf8 if applicable.

SET NAMES 'utf8';