Regular expression: Difference between revisions
Jump to navigation
Jump to search
→尋找英文字
(→尋找英文字) |
|||
| Line 465: | Line 465: | ||
FROM `my_table` | FROM `my_table` | ||
WHERE `my_column` LIKE CONVERT(`my_column` USING ASCII) | WHERE `my_column` LIKE CONVERT(`my_column` USING ASCII) | ||
</pre> | |||
<pre> | |||
-- 尋找欄位 `my_column` 欄位值是包含英文字、數字、破折號（-）或底線（_）的字串 | |||
SELECT * | |||
FROM `my_table` | |||
WHERE `my_column` REGEXP '[a-zA-Z0-9\-_]' | |||
</pre> | </pre> | ||