CODEWITHSUNDEEP
mysqlselect
Bambou
Bambou

Reputation: 1077

SQL Search doesn't find all values

I'm beginner in MySQL and I want to make a request to find all tables with this word "Ostéotomie", it works only if I write "%Ost%" and not "%Ostéotomie%" The fact is that it shows me only 4 results instead of the 9 I need.

Here is a SQL Fiddle to show what I mean : SQL Fiddle

The table wasn't created by me, I'm working on a search bar from a project which isn't mine. I don't know if you can help me, if I've putted enough information.

Thanks in advance.

Upvotes: 3

Views: 72

Answers (2)

Neeraj Wadhwa
Neeraj Wadhwa

Reputation: 737

I tried replacing é with % and the query gave me expected results.

Upvotes: 1

Cogeck
Cogeck

Reputation: 86

https://dev.mysql.com/doc/refman/8.0/en/charset-binary-collations.html

Maybe this solved your Problem.

Upvotes: 0

Related Questions