MySQL 5.7

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE t (
  `comment` VARCHAR(100)
);
INSERT INTO t VALUES
  ('55,44,1265,13,12'),
  ('12,55,1265,44,13'), 
  ('A45, or 45A or '),
  ('ABCDE52JQST 1265'),
  ('12 13 15 or a'),
  ('12 13 tactical 15 or a'),
  ('12 13 15 \'tactical\' or a'),
  ('123,212, '),
  ('haza12');
SELECT comment, REPLACE(`comment`, ' ', ',') comment_set
FROM t;


comment
comment_set


55,44,1265,13,12
55,44,1265,13,12

12,55,1265,44,13
12,55,1265,44,13

A45, or 45A or
A45,,or,45A,or,

ABCDE52JQST 1265
ABCDE52JQST,1265

12 13 15 or a
12,13,15,or,a

12 13 tactical 15 or a
12,13,tactical,15,or,a

12 13 15 'tactical' or a
12,13,15,'tactical',or,a

123,212,
123,212,,

haza12
haza12


SELECT *, REPLACE(comment, ' ', ',') comment_set
FROM t
WHERE FIND_IN_SET('45A', REPLACE(`comment`, ' ', ',')) > 0;


comment
comment_set


A45, or 45A or
A45,,or,45A,or,


SELECT *, REPLACE(comment, ' ', ',') comment_set
FROM t
WHERE FIND_IN_SET('1265', REPLACE(`comment`, ' ', ',')) > 0;


comment
comment_set


55,44,1265,13,12
55,44,1265,13,12

12,55,1265,44,13
12,55,1265,44,13

ABCDE52JQST 1265
ABCDE52JQST,1265


SELECT *, REPLACE(comment, ' ', ',') comment_set
FROM t
WHERE FIND_IN_SET('a', REPLACE(`comment`, ' ', ',')) > 0;


comment
comment_set


12 13 15 or a
12,13,15,or,a

12 13 tactical 15 or a
12,13,tactical,15,or,a

12 13 15 'tactical' or a
12,13,15,'tactical',or,a


SELECT *, REPLACE(comment, ' ', ',') comment_set
FROM t
WHERE FIND_IN_SET('ABCDE52JQST', REPLACE(`comment`, ' ', ',')) > 0;


comment
comment_set


ABCDE52JQST 1265
ABCDE52JQST,1265


SELECT *, REPLACE(comment, ' ', ',') comment_set
FROM t
WHERE FIND_IN_SET('tactical', REPLACE(`comment`, ' ', ',')) > 0;


comment
comment_set


12 13 tactical 15 or a
12,13,tactical,15,or,a


SELECT *, REPLACE(comment, ' ', ',') comment_set
FROM t
WHERE FIND_IN_SET('\'tactical\'', REPLACE(`comment`, ' ', ',')) > 0;


comment
comment_set


12 13 15 'tactical' or a
12,13,15,'tactical',or,a

comment	comment_set
55,44,1265,13,12	55,44,1265,13,12
12,55,1265,44,13	12,55,1265,44,13
A45, or 45A or	A45,,or,45A,or,
ABCDE52JQST 1265	ABCDE52JQST,1265
12 13 15 or a	12,13,15,or,a
12 13 tactical 15 or a	12,13,tactical,15,or,a
12 13 15 'tactical' or a	12,13,15,'tactical',or,a
123,212,	123,212,,
haza12	haza12