How can I SELECT data which in Arabic language in MYSQL?

Question

the following doesn't works, how can I search in data which stored in Arabic

SELECT * FROM `users` WHERE `name` LIKE = "%شريف%"

that gave me Error sql query

Answer 1

Use:

SELECT * FROM `users` WHERE `name` LIKE "%شريف%"