Regular expression: Difference between revisions

Regular expression (edit)

189 bytes added , 18 May 2023

Anonymous user

@@ Line 381: / Line 381: @@
 ==== Find non-ASCII characters in MySQL ====
-適用: 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><ref>[https://stackoverflow.com/questions/401771/how-can-i-find-non-ascii-characters-in-mysql How can I find non-ASCII characters in MySQL? - Stack Overflow]</ref>
+===== 尋找欄位值包含中文字 =====
+尋找 `column_name` 欄位值包含中文字。適用: 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><ref>[https://stackoverflow.com/questions/401771/how-can-i-find-non-ascii-characters-in-mysql How can I find non-ASCII characters in MySQL? - Stack Overflow]</ref>
 <pre>
--- 尋找 `column_name` 欄位值包含中文字
 SELECT `column_name`
 FROM `table_name`
@@ Line 390: / Line 390: @@
 <pre>
--- 尋找 `column_name` 欄位值不完全是 ASCII 字元
+SELECT `column_name`
+FROM `table_name`
+WHERE HEX(`column_name`) REGEXP '(E[4-9])';
+</pre>
+===== 尋找欄位值不完全是 ASCII 字元 =====
+尋找 `column_name` 欄位值不完全是 ASCII 字元
+<pre>
 SELECT `column_name`
 FROM `table_name`