Regular expression: Difference between revisions
Jump to navigation
Jump to search
→尋找英文字
mNo edit summary |
(→尋找英文字) |
||
| Line 430: | Line 430: | ||
=== 尋找英文字 === | === 尋找英文字 === | ||
<pre> | |||
-- 尋找欄位 `my_column` 欄位值是 ASCII 字元 | |||
SELECT * | |||
FROM `my_table` | |||
WHERE `my_column` LIKE CONVERT(`my_column` USING ASCII) | |||
</pre> | |||
* [https://errerrors.blogspot.com/2020/07/search-app-not-apple-in-englishsearching.html 解決英文字的搜尋：搜尋 app 而不是 apple] | * [https://errerrors.blogspot.com/2020/07/search-app-not-apple-in-englishsearching.html 解決英文字的搜尋：搜尋 app 而不是 apple] | ||
=== 將每行文字的行頭加上逗號符號 === | === 將每行文字的行頭加上逗號符號 === | ||