Examples of using Regexp in English and their translations into Chinese
{-}
-
Political
-
Ecclesiastic
-
Programming
As shown in the syntax description, a regular expression's exec method can be called either directly,(with regexp. exec(str)) or indirectly(with regexp(str)).
描述：就如在语法描述中的一样，正则表达工的exec方法能够被直接调用(使用regexp.exec(str))或者间接调用(使用regexp(str))。The REGEXP operator is more powerful.
REGEXP运算符功能更强大。LIKE, REGEXP, and SIMILAR TO: differences in character comparisons.
LIKE、REGEXP和SIMILARTO：字符比较上的差异.The underscore is not considered a metacharacter for REGEXP and REGEXP_SUBSTR.
不将百分号视为REGEXP和REGEXP_SUBSTR所使用的元字符。REGEXP expressions are never optimized.
REGEXP表达式永远不会被优化。Also, REGEXP and SIMILAR TO have a different default escape character.
另外，REGEXP和SIMILARTO还具有不同的缺省转义字符。When performing comparisons, REGEXP behavior is different from LIKE and SIMILAR TO.
在执行比较时，REGEXP的行为不同于LIKE和SIMILARTO。LIKE, REGEXP, and SIMILAR TO: Differences in pattern definition.
LIKE、REGEXP和SIMILARTO：pattern定义上的差异.LIKE, REGEXP, and SIMILAR TO: Differences in pattern definition.
LIKE、REGEXP和SIMILARTO：模式定义上的差异.REGEXP behavior matches closely with Perl 5(except where Perl syntax and operators are not supported).
REGEXP的行为与Perl5比较接近（除了不支持Perl语法和运算符的方面）。The REGEXP search condition and the REGEXP_SUBSTR function support all the syntax conventions in the table below, but the SIMILAR TO search expression does not.
REGEXP搜索条件和REGEXP_SUBSTR函数支持下表中的所有语法约定，但SIMILARTO搜索表达式不支持。Differences in matching Since REGEXP uses code point values, it only matches a literal in a pattern if it is the exact same character.
匹配上的差异因为REGEXP使用代码点值，所以只有它是完全相同的字符时才匹配模式中的文字。For REGEXP comparisons, the database server uses code point values in the database character set for comparisons.
对于REGEXP的比较，数据库服务器使用数据库字符集中的代码点值进行比较。REGEXP and REGEXP_SUBSTR When the caret is the first character in a character class, it matches anything other than the characters in the character set.
REGEXP和REGEXP_SUBSTR当脱字符为字符类中的第一个字符时，它与字符集中字符以外的任何字符匹配。REGEXP, LIKE, and SIMILAR TO search conditions differ in how you define pattern.
REGEXP、LIKE和SIMILARTO搜索条件的不同之处在于如何定义pattern：.In addition, for compatibility with other products, the REGEXP search condition supports several syntax extensions.
此外，为与其它产品兼容，REGEXP搜索条件还支持几个语法扩展。When used with REGEXP and REGEXP_SUBSTR, matches the end of a string.
当与REGEXP和REGEXP_SUBSTR一起使用时，匹配字符串的结尾字符。The REGEXP, LIKE, and SIMILAR TO search conditions are similar in that they all attempt to match a pattern to a string.
REGEXP、LIKE和SIMILARTO搜索条件都是试图将某个模式与字符串进行匹配，在这一方面它们是类似的。To demonstrate how extended regular expressions work, the LIKE queries shown previously are rewritten here to use REGEXP.
为了说明扩展正则表达式如何工作，上面所示的LIKE查询在下面使用REGEXP重写：.Whether the regular expression is being used with the SIMILAR TO or REGEXP search conditions, or the REGEXP_SUBSTR function.
正则表达式是与SIMILARTO或REGEXP搜索条件一起使用，还是与REGEXP_SUBSTR函数一起使用.
