Revision history [back]

The best way to insert text with special characters into SQL is to use single quotes to enclose the text. In the case of "Makin' Plans," the SQL statement would be:

INSERT INTO tablename (columnname) VALUES ('Makin'' Plans')

Note the use of two single quotes to represent the single quote within the text. This approach will work for any text that includes special characters, including double quotes, backslashes, and other characters that can cause issues when inserted directly into SQL.