I would like to escape the single quote in RLIKE input. I used double single quotes like so:

```
SELECT * FROM TABLE
WHERE column RLIKE 'o''brien'

```

But it returned the results with `"obrien"` rather than `"o'brien"`. I tried `"\\'"` instead of double single quotes too, but that doesn't work either. So what is the correct escape character for single quote?