I have a temp table containg wildcarded strings and I want to select values froma different table using “like” against all those wildcarded values. Here’s the example...
create temporary table match_these (val varchar(32));
insert into match_these (val) values (‘jo%’);
insert into match_these (val) values (‘%denn_’);
insert into match_these (val) values (‘alt%’);
create table footable (name varchar(32));
(insert a bunch of records)
Now...
select * from footable where name in (select val from match_these)
... won’t work because “in” implies equality. I want something like...
select * from footable where name like (select val from match_these)
... but that doesn’t work because the subquery returns more than one row :-(
Any elegant sql solutions out there before I brute-force a solution ?
Thanks in Advance !