Skip to content

Instantly share code, notes, and snippets.

@VehpuS

VehpuS/sql-select-by-value-in-array.sql

Last active April 25, 2024 07:56
Show Gist options
  • Save VehpuS/fbf41809ed3c4cdc214b223f9b1da4ab to your computer and use it in GitHub Desktop.
Save VehpuS/fbf41809ed3c4cdc214b223f9b1da4ab to your computer and use it in GitHub Desktop.
Download ZIP
SQL select by value in a array
Raw
sql-select-by-value-in-array.sql
SELECT id, column FROM table
where id::VARCHAR = ANY (ARRAY['b329a9b1-54fb-4d5e-853e-4c58555ab0de', 'fc666e0a-0dd1-4d02-990c-4ae52324da36'])
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment