When I do this:
SELECT rule FROM filter;
I want to see this:
name = 'John'
How do I insert test data with the single quotes, i.e.
INSERT INTO filter (rule) values (name = \'John\').
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.