retrieving query with quoted using LIKE

Here's the basic query, I'm trying to retrive a table that has Cici's, but since it's in sql it's Cici\'s. Here's the results I'm getting thus far.

Code:

---

SELECT display FROM users WHERE display LIKE '%Cici%'  ; returns as should
SELECT display FROM users WHERE display LIKE '%Cici\'%'; returns nothing
SELECT display FROM users WHERE display LIKE '%i\'%'    ; returns nothing
SELECT display FROM users WHERE display LIKE '%\'%'    ; returns all quoted

---

Am I missing something here that there's supposed to be something in between the actual letters of the word and the escaped letters