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 11:35, 28 June 2017
, 28 June 2017→Highlight search query keywords on resulting pages
| Line 41: | Line 41: | ||
<pre> | <pre> | ||
SET @term := "吸星大法"; | |||
SET @message := "笑傲江湖中嵩山派掌門左冷禪所創掌法，可發出至陰至寒的真氣。左冷禪與任我行比武時，以此功對付吸星大法，使其全身凍僵、天池穴被封;與岳不群比劍奪帥時，左又使出寒冰神掌，與紫霞神功旗鼓相當、不分勝敗。 | SET @message := "笑傲江湖中嵩山派掌門左冷禪所創掌法，可發出至陰至寒的真氣。左冷禪與任我行比武時，以此功對付吸星大法，使其全身凍僵、天池穴被封;與岳不群比劍奪帥時，左又使出寒冰神掌，與紫霞神功旗鼓相當、不分勝敗。 | ||
| Line 50: | Line 52: | ||
, CASE | , CASE | ||
WHEN POSITION( | WHEN POSITION(@term IN @message) > 0 THEN SUBSTRING(@message | ||
, IF( | , IF( | ||
POSITION( | POSITION(@term IN @message) > 0 && | ||
POSITION( | POSITION(@term IN @message) -10 < 0 | ||
, 1 | , 1 | ||
, POSITION( | , POSITION(@term IN @message) -10) | ||
, CHAR_LENGTH( | , CHAR_LENGTH(@term) + 20 | ||
) | ) | ||
ELSE '' | ELSE '' | ||
| Line 67: | Line 69: | ||
<pre> | <pre> | ||
SET @term := "吸星大法"; | |||
SET @message := "原文網址：https://kknews.cc/zh-tw/culture/xzaxbq.html"; | SET @message := "原文網址：https://kknews.cc/zh-tw/culture/xzaxbq.html"; | ||
| Line 74: | Line 77: | ||
, CASE | , CASE | ||
WHEN POSITION( | WHEN POSITION(@term IN @message) > 0 THEN SUBSTRING(@message | ||
, IF( | , IF( | ||
POSITION( | POSITION(@term IN @message) > 0 && | ||
POSITION( | POSITION(@term IN @message) -10 < 0 | ||
, 1 | , 1 | ||
, POSITION( | , POSITION(@term IN @message) -10) | ||
, CHAR_LENGTH( | , CHAR_LENGTH(@term) + 20 | ||
) | ) | ||
ELSE '' | ELSE '' | ||