Re: MATCH Keywords with Spaces AGAINST Large Text

[Peter Brawley]

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.