Good morning.
I have a table in the database and I need to make 2 selects in it:
For the first search I'm using this and returning everything I need:
SELECT * FROM wp_memoria WHERE memo_de IN ($words)
The second, I need to search case-sensitive and accent-sensitive, but I can not make it work at all. A solution I found gave me this result:
SELECT * FROM wp_memoria WHERE CAST(memo_de AS CHAR CHARACTER SET latin1) COLLATE latin1_general_cs_ai IN ($words) AND status = 1
But it does not work when the search has an accent in the middle.
Here's how my table structure looks: 