Two single quotes without a space in between them must be used to match a single quote that is part of 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-quote (") is not a special character within the pattern string, and can be used like any letter or digit.
|