2024-03-28 14:44:20 • PostgreSQL
DB:Table JSON Type Field Select Query
DB->table JSON Field Query 

$results = DB::table('prom_prd_remain_log')
->whereRaw("EXISTS (SELECT 1 FROM json_array_elements(display_data) AS arr_display_data WHERE (arr_display_data->>'remainCount')::int = 77)")
->get();
2 Comments
Jordan Singer
2d
Lorem ipsum, dolor sit amet consectetur adipisicing elit. Non minima ipsum at amet doloremque qui magni, placeat deserunt pariatur itaque laudantium impedit aliquam eligendi repellendus excepturi quibusdam nobis esse accusantium.
2 replies
Brandon Smith
2d
Lorem ipsum dolor sit, amet consectetur adipisicing elit.
James Parsons
1d
Lorem ipsum dolor sit amet, consectetur adipisicing elit. Distinctio dolore sed eos sapiente, praesentium.
Santiago Roberts
4d
Lorem ipsum dolor sit amet consectetur adipisicing elit. Iusto laborum in corrupti dolorum, quas delectus nobis porro accusantium molestias sequi.