BartlomiejSkwira
2/5/2018 - 9:25 AM

SQL - LIKE/ILIKE + IN in Postgresql

Do an LIKE/ILIKE search on an array of strings in PostgreSQL

#rails
.where('products.name ILIKE ANY (array[?])', params.product_name)