티스토리 뷰

공부

[SQL] dynamic like

승가비 2022. 12. 7. 11:30
728x90
SELECT column 
  FROM table AS T1
       INNER JOIN Params AS P1
          ON T1.column LIKE '%' + P1.param + '%';

https://stackoverflow.com/questions/4612282/dynamic-like-statement-in-sql

 

Dynamic Like Statement in SQL

I've been racking my brain on how to do this for a while, and i know that some genius on this site will have the answer. Basically i'm trying to do this: SELECT column FROM table WHERE [tabl...

stackoverflow.com

 

728x90
저작자표시 비영리

'공부' 카테고리의 다른 글

[airflow] jinja template kwargs["ds"]  (0) 2022.12.11
[hive] REFRESH TABLE db.table  (0) 2022.12.11
[bitbucket] pipelines `atlassian/aws-s3-deploy:0.3.8` force add sub path  (0) 2022.12.07
[spark] `spark.yarn.stagingDir`  (0) 2022.12.06
[python] jinja2 + f-string  (0) 2022.12.06
댓글