By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE IF NOT EXISTS `things` (
`id` int(6) unsigned NOT NULL,
`name` varchar(200) NOT NULL,
`stats` varchar(200) NOT NULL,
PRIMARY KEY (`id`)
) DEFAULT CHARSET=utf8;
INSERT INTO `things` (`id`, `name`, `stats`) VALUES
('1', 'thing1', 'AD, BM, WK'),
('2', 'thing2', 'WC'),
('3', 'thing3', 'SP, BM'),
('4', 'thing4', 'AD, BM, BM, AD'),
('5', 'thing5', 'M'),
('6', 'thing6', 'X, TK'),
('7', 'thing7', 'TK, M');
SET @code := 'M';
SELECT *
FROM things
WHERE stats RLIKE
CONCAT('(^| )',@code,'(,|$)')
| id | name | stats |
|---|---|---|
| 5 | thing5 | M |
| 7 | thing7 | TK, M |
SET @code := 'M';
SELECT *
FROM things
WHERE CONCAT(' ',stats,',')
LIKE CONCAT('% ',@code,',%')
| id | name | stats |
|---|---|---|
| 5 | thing5 | M |
| 7 | thing7 | TK, M |