MySQL Forums
Forum List  »  Full-Text Search

Re: MATCH Keywords with Spaces AGAINST Large Text
Posted by: Peter Brawley
Date: December 05, 2021 12:08PM

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.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: MATCH Keywords with Spaces AGAINST Large Text
57
December 05, 2021 12:08PM


Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.