If the keyword column is a json blob, you might be able to do it with JSON_CONTAINS: https://dev.mysql.com/doc/refman/8.0/en/json-search-functions.html#functio

If the keyword column is a json blob, you might be able to do it with JSON_CONTAINS: https://dev.mysql.com/doc/refman/8.0/en/json-search-functions.html#function_json-contains https://dev.mysql.com/doc/refman/8.0/en/json-search-function... (Unless you are using mongo on the backend, in which case I am not familiar with that)