Revision history [back]

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.