공부
[SQL] LIKE subquery
승가비
2021. 2. 9. 01:05
728x90
SELECT t.*
FROM t
WHERE EXISTS (
SELECT 1
FROM tt
WHERE t.name LIKE '%' || tt.name || '%'
);https://dba.stackexchange.com/questions/124844/how-to-use-like-with-subquery/124846#124846
How to use LIKE with subquery?
In a SQLITE3 DB, I have a table A with a column 'word' containing search words that partially match a column in another table B. I'd like to SELECT all rows FROM table B WHERE B.name LIKE %
dba.stackexchange.com
728x90