Search
 
SCRIPT & CODE EXAMPLE
 

SQL

postgres in operator with comma separated values

select *
from DUALS
where num in (select unnest (string_to_array('1,2', ',')::integer[]))
Comment

PREVIOUS NEXT
Code Example
Sql :: installing postgresql ubuntu 
Sql :: alter table auto_increment 
Sql :: oracle add datafile to tablespace 
Sql :: centos 8 install mysql 
Sql :: postgres concat_ws 
Sql :: combine two columns using sql query 
Sql :: sql auto date 
Sql :: mysql convert column to uppercase 
Sql :: where clause for child record apex 
Sql :: add unique constraint sql server multiple columns 
Sql :: safe mysql 
Sql :: mysql reset root password 
Sql :: sql update table based on another table 
Sql :: date_trunc postgres 
Sql :: create in sql 
Sql :: buscar nombre de columna en todas las tablas sql server 
Sql :: get day in sql 
Sql :: create unique index postgres 
Sql :: list all columns in a table sql 
Sql :: SELECT table_name FROM user_tables; 
Sql :: SET NOCOUNT ON; 
Sql :: alter table add column forigen key mysql 
Sql :: mysql version query 
Sql :: select all tables sql 
Sql :: mysql show table structure 
Sql :: oracle sql date get month 
Sql :: select last 2 characters sql 
Sql :: sql select second max 
Sql :: update from table tsql 
Sql :: sql server list locks 
ADD CONTENT
Topic
Content
Source link
Name
3+6 =