CODEWITHSUNDEEP
mysql
Sebastian Corneliu Vîrlan
Sebastian Corneliu Vîrlan

Reputation: 1700

Select from database where string = same string with diacritics

How can I select from database by given string and mysql to return the row on same string with diacritics?

select * from myTable where nume = "Stefan"

and the row from database that should be returned:

id = 1 
name = "Ștefan"

Upvotes: 1

Views: 109

Answers (1)

Alex Tartan
Alex Tartan

Reputation: 6836

You can search like:

SELECT * from myTable 
where 
CONVERT(nume USING utf8) LIKE '%Stefan%'

But this is a bit unclear, as MySql already know how to search for strings with diactritics.

Upvotes: 1

Related Questions