15,032
edits
MySQL full text search equivalents to Google search: Difference between revisions
Jump to navigation
Jump to search
MySQL full text search equivalents to Google search (edit)
Revision as of 17:22, 16 October 2017
, 16 October 2017→Google sheet approach
(→Microsoft Spreadsheet approach: fix #NUM! 「MID 函式第 2 參數」的值是 _。這項參數的值應大於或等於 1。) |
|||
| Line 111: | Line 111: | ||
=== Google sheet approach === | === Google sheet approach === | ||
Using [https://support.google.com/docs/answer/3098244?hl=zh-Hant REGEXEXTRACT] function: | Using [https://support.google.com/docs/answer/3098244?hl=zh-Hant REGEXEXTRACT] function {{exclaim}} case-sensitive!: | ||
<table border="1"> | <table border="1"> | ||
<tr> | <tr> | ||
| Line 136: | Line 136: | ||
</tr> | </tr> | ||
</table> | </table> | ||
=== Microsoft Spreadsheet approach === | === Microsoft Spreadsheet approach === | ||