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.