Apostrophe

How to build a statement on a word with an Apostrophe such as WHERE name='Tom's Book'

schema:scott

DROP TABLE cia;

CREATE TABLE cia(name VARCHAR(10), region VARCHAR(10));
INSERT INTO cia VALUES ('Cote d''Ivoire', 'Africa');
INSERT INTO cia VALUES ('Japan', 'Asia');

SELECT * FROM cia
WHERE name = 'Cote d''Ivoire'

SELECT * FROM cia
WHERE name = 'Cote d''Ivoire'

Use two apostrophes.

SELECT Operations

Concatenate Columns

Like

Union

Apostrophe

Full text search

Column name

Equi Join

Column name with spaces

NULL