mysql_正则匹配中文（国外英文资料）.docVIP

mysql_正则匹配中文（国外英文资料） Mysql regularly matches Chinese Use the HEX in mysql to convert the field to 2, then match the code code in Chinese. Our field stores utf8, so we query the utf8 character encoding table (if yours is GBK, check the corresponding code controls) Chinese character e [4-9] [0-9a-f] {4} Numbers (3 [0-9]) The letters (4 [0-9a-f] | 5 [0-9a] | 6 [0-9a-f] | 7 [0-9a]) correspond to the code The regular can be written as: HEX (name) the REGEXP [[: :]] (e [4-9] [0-9] a - f {4} | 3 | 4 [0-9] [0-9] a - f | 5 [0-9] a | 6 [0-9 a - f] 7 [0-9 a] | | 5 f) + [[: :]] [[:]] and [[:] [:] [:] [:]] REG_EXP_DATE = ^ (( [0-9] | [1-9] | [0-9] | [0-9] {1} [0-9] [0-9] [0-9] [0-9] ( ((0 [13578] [02] | 1) - (0 | [1-9] [12] [0-9] [01]) | 3) | ((0 [469] 11) | - (0 [1-9] | [12] [0-9] | 30)) | (02 - (0 [1-9] | [1] [0-9] | 2-8 0)) )) | ((([0-9] {2}) (0 [48] | [2468] [048] | [13579] [26]) | ((0 [48] | [2468] [048] | [3579] [26]) 00)) - 02-29)) \ \ s + ([0, 1]? [0-9] [0, 3] | 2) - ([0 to 5] [0-9]) - ([0 to 5] [0-9]) $; The corresponding database is yyyy-mm-dd hh24-mi-ss (0 [13578] | 1 [02]) | (0 [469] |) | 02 Special characters in regular expressions Character / Meaning: for characters, it is usually literal, pointing out that the following characters are special characters, not explained. For example: / b/match character b, which becomes a special character by adding a backslash in front of b, which is the/b / Match the boundary of a word. Or: For a few characters, the general explanation is special, indicating that the following characters are not special, and should be interpreted literally. For example: * is a special character that matches any character (including 0 characters); For example: / a * / means to match 0 or more a. To match the literal *, put a backslash in front of a; For example: / a * / match a *. The character ^ Meaning: the character that represents the match must be in the front. For example: / ^ A/mismatch \ the an A, \ in the A, but match \ an a. \ in front o