MySQL full text search equivalents to Google search: Difference between revisions
Jump to navigation
Jump to search
m
MySQL full text search equivalents to Google search (edit)
Revision as of 14:43, 16 June 2021
, 16 June 2021→SQL syntax
m (→Instructions) |
m (→SQL syntax) |
||
| Line 82: | Line 82: | ||
) | ) | ||
ELSE '' | ELSE '' | ||
END AS | END AS `scrapbook` | ||
-- Returned result of scrapbook column: Show 10 characters before or after the search keywords. | -- Returned result of scrapbook column: Show 10 characters before or after the search keywords. | ||
| Line 89: | Line 89: | ||
Run on [http://sqlfiddle.com/#!9/096df3/5/0 sqlfiddle] | Run on [http://sqlfiddle.com/#!9/096df3/5/0 sqlfiddle] | ||
==== Instruction of SQL syntax ==== | ==== Instruction of SQL syntax ==== | ||