How to search for special characters, unicode char

2019-09-02 03:29发布

问题:

I am saving Emoji's with charset utfmb4_general_ci, Storing and retrieving are working fine but when i try to search for the information with a string containing Emoji's or special characters i am not getting the result. It always returning empty.

Can somebody help to solve this?

CODE

select * from table where Title LIKE '%Kanye West - \"Bound 2\" PARODY%'

UPDATE:

The search string are like

  1. Kanye%20West%20-%20"Bound%202"%20PARODY

    Stored in database like Kanye West - \"Bound 2\" PARODY

  2. Family%20guy%20