Skip to content

Instantly share code, notes, and snippets.

@ppazos

ppazos/sql_like_or_from_list.groovy

Created February 7, 2025 17:16
Show Gist options
  • Save ppazos/df8b5c20d3fc2e457e426595efea9298 to your computer and use it in GitHub Desktop.
Save ppazos/df8b5c20d3fc2e457e426595efea9298 to your computer and use it in GitHub Desktop.
Download ZIP
SQL LIKE OR from list
Raw
sql_like_or_from_list.groovy
def a = ["a", "b", "c"]
"value LIKE "+ a.collect {"'%"+ it + "%'"}.join(" OR value LIKE ")
// value LIKE '%a%' OR value LIKE '%b%' OR value LIKE '%c%'
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment