You can use the MySQL LIKE
operator with wildcard characters to locate words that are adjacent to the searched keyword. Here is an example query:
SELECT * FROM table_name WHERE column_name LIKE '%keyword _ word%';
In this query, the underscore character represents a single space, so this will match any occurrence of the keyword followed by one word, then another word (adjacent to each other, separated by a single space). The percent signs on either side of the search pattern indicate that there may be any number of characters before or after the matched pattern.
Asked: 2022-08-09 11:00:00 +0000
Seen: 9 times
Last updated: Oct 02 '22