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 12:00, 17 October 2017
, 17 October 2017→Google sheet approach
| Line 133: | Line 133: | ||
<td>3</td> | <td>3</td> | ||
<td>搜尋結果摘要</td> | <td>搜尋結果摘要</td> | ||
<td>{{kbd | key=<nowiki>=IF(ISERROR(REGEXEXTRACT(B1, "(.{10}"&B2&".{10})")), "", REGEXEXTRACT(B1, "(.{10}"&B2&".{10})"))</nowiki>}}</td> | <td>{{kbd | key=<nowiki>=IF(ISERROR(REGEXEXTRACT(LOWER(B1), "(.{10}"&B2&".{10})")), "", REGEXEXTRACT(LOWER(B1), "(.{10}"&B2&".{10})"))</nowiki>}}</td> | ||
</tr> | </tr> | ||
</table> | </table> | ||