14,953
edits
Regular expression: Difference between revisions
Jump to navigation
Jump to search
→尋找中文、非英文的文字
No edit summary |
|||
| Line 337: | Line 337: | ||
</pre> | </pre> | ||
適用: Total commander 的 Multi-Rename tool<ref>取代非英文的文字，但是不包含 . 符號: <nowiki>[^\u0000-\u0080|.]+ </nowiki></ref> | 適用: Total commander 的 Multi-Rename tool<ref>取代非英文的文字，但是不包含 . 符號: <nowiki>[^\u0000-\u0080|.]+ </nowiki></ref><ref>[http://stackoverflow.com/questions/150033/regular-expression-to-match-non-english-characters javascript - Regular expression to match non-english characters? - Stack Overflow]</ref> | ||
<pre> | <pre> | ||
[^\u0000-\u0080]+ | [^\u0000-\u0080]+ | ||
</pre> | </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> | <pre> | ||
# Table `table_name` contains the Chinese characters | # Table `table_name` contains the Chinese characters | ||
| Line 350: | Line 350: | ||
</pre> | </pre> | ||
尋找欄位值包含中文字，中文字包含繁體中文與簡體中文，不包含特殊符號，例如 Emoji：{{kbd | key = ⭐}}。 | |||
PHP: | PHP: | ||
<pre> | <pre> | ||