$re = '/["\'`](?:(?<=")[^"\\\\]*(?s:\\\\.[^"\\\\]*)*"|(?<=\')[^\'\\\\]*(?s:\\\\.[^\'\\\\]*)*\'|[^`]*`)/';
$str = 'Almost every SQL statement uses `identifier`s in some way to refer to a database or its constituent elements such as tables, views, columns, indexes, stored routines, triggers, or events. When you refer to elements of databases, `identifier`s must conform to the following rules.
Legal characters in `identifier`s. Unquoted `identifier`s may consist of latin letters a-z in any lettercase, digits 0-9, dollar, underscore, and Unicode extended characters in the range U+0080 to U+FFFF. `Identifier`s can start with any character that is legal in an `identifier`, including a digit. However, an unquoted `identifier` cannot consist entirely of digits because that would make it indistinguishable from a number. MySQL’s support for `identifier`s that begin with a number is somewhat unusual among database systems. If you use such an identifier, take particular care if it contains an \'E\' or \'e\' because those characters can lead to ambiguous expressions. For example, the expression 23e + 14 (with spaces surrounding the \'+\' sign) means column 23e plus the number 14, but what about 23e+14? Does it mean the same thing, or is it a number in scientific notation?
`Identifier`s can be "quoted" (delimited) within backtick characters (\'`\'), which permits use of any character except a NUL byte or Unicode supplementary characters (U+10000 and up):
"string \\"string\\" string"
"string \\\\"string\\\\" string"
\'string \\\'string\\\' string\'
\'string \\\\\'string\\\\\' string\'
`string string`
`string `string` string`';
preg_match_all($re, $str, $matches, PREG_SET_ORDER, 0);
// Print the entire match result
var_dump($matches);
Please keep in mind that these code samples are automatically generated and are not guaranteed to work. If you find any syntax errors, feel free to submit a bug report. For a full regex reference for PHP, please visit: http://php.net/manual/en/ref.pcre.php