Search
 
SCRIPT & CODE EXAMPLE
 

SQL

postgresql search object in array

select r.id, e.*
from records r
  cross join lateral jsonb_array_elements(r.data -> 'entries') as e
where e ->> 'name' like '%Doe%';
Comment

postgresql search object in array

select r.*
from records r
where exists (select 1 
             from jsonb_array_elements(r.data -> 'entries') as e
             where e ->> 'name' like '%Doe%');
Comment

PREVIOUS NEXT
Code Example
Sql :: sqlite create table if not exists 
Sql :: sqlite3 show columns name 
Sql :: sql where keyword 
Sql :: SQL rounding numbers 
Sql :: phone number sql 
Sql :: sql server update column based on another table 
Sql :: django mssql backend 
Sql :: how to add where command in update comand with joins 
Sql :: find duplicate users by email address in mysql 
Sql :: locate sql server 
Sql :: flask sqlalchemy filter multiple conditions 
Sql :: mysql url 
Sql :: mysql get year from date 
Sql :: postgres datetime now 
Sql :: sql identity column reset 
Sql :: mac install mysql 
Sql :: psql fatal database does not exist 
Sql :: identify number of rows in sql 
Sql :: how to find lowest in sql 
Sql :: sqlite truncate tables command 
Sql :: add current timestamp in mysql 
Sql :: phpmyadmin reset root password 
Sql :: if else in plsql 
Sql :: check duplicate values plsql 
Sql :: mysql show views 
Sql :: mysql count number of occurrences in a column 
Sql :: mysql event last execution 
Sql :: check lock on table in sql server 
Sql :: view databases in mysql 
Sql :: sql list dates between two dates 
ADD CONTENT
Topic
Content
Source link
Name
4+7 =