Regular expression: Difference between revisions

Regular expression (edit)

348 bytes added , 4 January 2018

15,039

edits

@@ Line 340: / Line 340: @@
 <pre>
 [^\u0000-\u0080]+
+</pre>
+適用: MySQL<ref>[https://stackoverflow.com/questions/9795137/how-to-detect-rows-with-chinese-characters-in-mysql How to detect rows with chinese characters in MySQL? - Stack Overflow]</ref>
+<pre>
+# Table `table_name` contains the Chinese characters
+SELECT `column_name`
+FROM `table_name`
+WHERE HEX(`column_name`) REGEXP '^(..)*(E[4-9])';
 </pre>