inserting single quotes in column

Yello.

When I do this:

SELECT rule FROM filter;

I want to see this:

name = 'John'

So....

How do I insert test data with the single quotes, i.e.

INSERT INTO filter (rule) values (name = \'John\').

Thanks.

p.s. I did a search but it wasn't making sense, because people were saying use CHAR(32) or something like that, I don't understand.

Try:

Code:

---

INSERT INTO filter (rule) values (name = '''John''');
-- or --
INSERT INTO filter (rule) values (name = CHR(39)||'John'||CHR(39));

---

;)