Two single quotation marks with no space between them must be used to match a single quotation mark in the result string. For example, if a row in the database contains the value “Jim’s house,” you can match this pattern by specifying LIKE 'Jim''s house' in the WHERE clause. A double-quotation mark in the pattern string is not a special character and can be used like any letter or digit.
|