Examples of using Regexp in Chinese and their translations into English
{-}
-
Political
-
Ecclesiastic
-
Programming
LIKE、REGEXP和SIMILARTO：字符比较上的差异.
LIKE, REGEXP, and SIMILAR TO: differences in character comparisons.不将百分号视为REGEXP和REGEXP_SUBSTR所使用的元字符。
The underscore is not considered a metacharacter for REGEXP and REGEXP_SUBSTR.REGEXP表达式永远不会被优化。
REGEXP expressions are never optimized.另外，REGEXP和SIMILARTO还具有不同的缺省转义字符。
Also, REGEXP and SIMILAR TO have a different default escape character.在执行比较时，REGEXP的行为不同于LIKE和SIMILARTO。
When performing comparisons, REGEXP behavior is different from LIKE and SIMILAR TO.LIKE、REGEXP和SIMILARTO：pattern定义上的差异.
LIKE, REGEXP, and SIMILAR TO: Differences in pattern definition.LIKE、REGEXP和SIMILARTO：模式定义上的差异.
LIKE, REGEXP, and SIMILAR TO: Differences in pattern definition.REGEXP的行为与Perl5比较接近（除了不支持Perl语法和运算符的方面）。
REGEXP behavior matches closely with Perl 5(except where Perl syntax and operators are not supported).REGEXP搜索条件和REGEXP_SUBSTR函数支持下表中的所有语法约定，但SIMILARTO搜索表达式不支持。
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使用代码点值，所以只有它是完全相同的字符时才匹配模式中的文字。
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_SUBSTR当脱字符为字符类中的第一个字符时，它与字符集中字符以外的任何字符匹配。
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、LIKE和SIMILARTO搜索条件的不同之处在于如何定义pattern：.
REGEXP, LIKE, and SIMILAR TO search conditions differ in how you define pattern.此外，为与其它产品兼容，REGEXP搜索条件还支持几个语法扩展。
In addition, for compatibility with other products, the REGEXP search condition supports several syntax extensions.当与REGEXP和REGEXP_SUBSTR一起使用时，匹配字符串的结尾字符。
When used with REGEXP and REGEXP_SUBSTR, matches the end of a string.REGEXP、LIKE和SIMILARTO搜索条件都是试图将某个模式与字符串进行匹配，在这一方面它们是类似的。
The REGEXP, LIKE, and SIMILAR TO search conditions are similar in that they all attempt to match a pattern to a string.为了说明扩展正则表达式如何工作，上面所示的LIKE查询在下面使用REGEXP重写：.
To demonstrate how extended regular expressions work, the LIKE queries shown previously are rewritten here to use REGEXP.正则表达式是与SIMILARTO或REGEXP搜索条件一起使用，还是与REGEXP_SUBSTR函数一起使用.
Whether the regular expression is being used with the SIMILAR TO or REGEXP search conditions, or the REGEXP_SUBSTR function.字符比较方法不同意味着REGEXP和LIKE/SIMILAR的匹配及范围计算的结果也不同。
The difference in character comparison methods means that results 正则表达式已经对SIMILARTO和REGEXP搜索条件以及REGEXP_SUBSTR函数的行为进行了更改。
Regular expressions are supported with 
