/SQL/Sql join on wildcard

Sql join on wildcard

Sql join on wildcard

select *
from tableA a
where exists (select 1 from tableB b where  a.id like '%' + b.id + '%');

0

Source: stackoverflow.com

Sql join on wildcard

select *
from tableA a join
     tableB b
     on a.id like '%' + b.id + '%';

0

Source: stackoverflow.com

Similar codes

0 vote292 views2 answers
Plsql regex match whole word
SQL
2 votes312 views1 answer
How to find table table in stored procedure sql server
SQL
0 vote372 views1 answer
Mysql show schema
SQL
1 vote294 views2 answers
Mysql allow remote connections
SQL
0 vote313 views1 answer
See the structure of a table mysql
SQL
0 vote283 views2 answers
SQL Server log file truncate - Source :NAYCode.com
SQL
13 votes234 views2 answers
Oracle all source
SQL
0 vote280 views1 answer
Datagrip exec
SQL
2 votes291 views1 answer
Illuminate\Database\QueryException : SQLSTATE[HY000] [1698] Access denied for user 'root'@'localhost'
SQL
0 vote260 views1 answer
Mysql workbench search all tables
SQL

Share