Yes, apologies for the blunder, that's what I meant.
drop table if exists kvals;
create table kvals(kid int unsigned, kval varchar(255) );
insert into kvals values
(1, 'MySQL'),
(2, 'Database Developer'),
(3, 'Software Engineer'),
(4, 'Director of Development');
set @s = "I am a Senior Software Engineer with Director of Development experience specializing in JavaScript, JSON, and Web Development. I also have Management experience and have worked in Banking, Cloud, and custom CRM development environments. I am also familiar with .NET and Kittens.";
select kid,kval
from kvals
where @s like concat('%',kval,'%');
+------+-------------------------+
| kid | kval |
+------+-------------------------+
| 3 | Software Engineer |
| 4 | Director of Development |
+------+-------------------------+
set @s2 = "I am a Senior Software Developer with Director of Development experience specializing in JavaScript, JSON, and Web Development. I also have Management experience and have worked in Banking, Cloud, and custom CRM development environments. I am also familiar with .NET and Kittens.";
select kid,kval
from kvals
where @s2 like concat('%',kval,'%');
+------+-------------------------+
| kid | kval |
+------+-------------------------+
| 4 | Director of Development |
+------+-------------------------+
Edited 1 time(s). Last edit at 12/05/2021 12:26PM by Peter Brawley.