Apostrophe

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

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