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 21:15, 30 September 2017
, 30 September 2017→Microsoft Spreadsheet approach: fix #NUM! 「MID 函式第 2 參數」的值是 _。這項參數的值應大於或等於 1。
(→Microsoft Spreadsheet approach: fix #NUM! 「MID 函式第 2 參數」的值是 _。這項參數的值應大於或等於 1。) |
|||
| Line 161: | Line 161: | ||
<td>3</td> | <td>3</td> | ||
<td>搜尋結果摘要</td> | <td>搜尋結果摘要</td> | ||
<td>{{kbd | key=<nowiki>=IF(ISERROR(FIND(B2, B1)), "", CONCATENATE(MID(B1, FIND(B2, B1)-10, 10), MID(B1, FIND(B2, B1), 10+LEN(B2))))</nowiki>}}</td> | <td>{{kbd | key=<nowiki>=IF(ISERROR(FIND(B2, B1)), "", CONCATENATE(MID(B1, IF(FIND(B2, B1)-10 >= 1, FIND(B2, B1)-10, 1), 10), MID(B1, FIND(B2, B1), 10+LEN(B2))))</nowiki>}}</td> | ||
</tr> | </tr> | ||
</table> | </table> | ||