-
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.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|