スペース区切の文章のカラムに対して、特定の単語を含むレコードを表示するSQL
以下のサイトで実験できます。
http://sqlfiddle.com/#!18/4a8d3b/7
スキーマ:
CREATE TABLE ForgeRock
([productName] varchar(23), [description] varchar(57))
;
INSERT INTO ForgeRock
([productName], [description])
VALUES
('OpenIDM', 'Platform for building enterprise provisioning solutions'),
('OpenDJ', 'Robust LDAP server for Java'),
('OpenAM', 'Full-featured access management'),
('OpenAM', 'Full-featured access management'),
('OpenDJ', 'Robust LDAP server for Java'),
('OpenDJ', 'Robust LDAP server for Java')
;
SQL:
SELECT *
FROM ForgeRock
where (SELECT COUNT(*) FROM STRING_SPLIT([description], ' ') WHERE value = 'for') > 0