SELECT *
FROM your_table
WHERE your_column LIKE ANY (SELECT CONCAT('%', your_string, '%') FROM keyword_list);

CREATE TABLE IF NOT EXISTS ezy_data_indices (
    id bigint unsigned NOT NULL AUTO_INCREMENT,
    data_type varchar(120) COLLATE utf8mb4_unicode_520_ci NOT NULL,
    data_id bigint unsigned NOT NULL,
    keyword varchar(300) COLLATE utf8mb4_unicode_520_ci NOT NULL,
    priority int unsigned NOT NULL,
    created_at datetime NOT NULL,
    updated_at datetime NOT NULL,
    PRIMARY KEY (id),
    UNIQUE KEY key_data_type_id_keyword (data_type, data_id, keyword),
    INDEX index_data_type (data_type),
    INDEX index_data_id (data_id),
    INDEX index_keyword (keyword),
    INDEX index_priority (priority),
    INDEX index_created_at (created_at),
    INDEX index_updated_at (updated_at)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

select data_id from ezy_data_indices where data_type = ? and keyword in keyword_list