MySQL full text search equivalents to Google search: Difference between revisions

Jump to navigation Jump to search
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>

Navigation menu