Select String-Literal Example
Literal strings are represented as single-quoted strings. If the string itself contains a single-quote or apostrophe, the character must be preceded by another single-quote.
SELECT * FROM t1 WHERE c1 = ’Roberta’s Restaurant’
SELECT STREET FROM address WHERE city LIKE ’San%’
Thursday, 18 April 2019 Posted in Example SQL Statements