Postgres 14

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

create table SearchTerms (ID serial primary key, sessionID varchar(25), searchTerm varchar(50));
insert into SearchTerms (sessionID, searchTerm) values
('0129205017_smith', 'foo'), 
('0129205017_smith', 'someval1'), 
('0129205017_smith', 'anotherval2'), 
('0129205017_smith', 'bar');
4 rows affected

select * from searchTerms 
where searchTerm ~ 'val1|val2';


id
sessionid
searchterm


2
0129205017_smith
someval1

3
0129205017_smith
anotherval2


select * from searchTerms s
join (SELECT 'val1' as term UNION ALL SELECT 'val2' as term) v
on s.searchTerm like concat('%', v.term, '%');


id
sessionid
searchterm
term


2
0129205017_smith
someval1
val1

3
0129205017_smith
anotherval2
val2

id	sessionid	searchterm	term
2	0129205017_smith	someval1	val1
3	0129205017_smith	anotherval2	val2