Member::whereJsonContains()

datadump.sql

INSERT INTO `members` (`id`, `name`, `msisdn`, `token`, `api_token`, `settings`, `created_at`, `updated_at`)
VALUES
	(1, NULL, '343434343434', '303273', 'GIUalPNIiiBIiQsBeJDeeMvxhgL9wrDOrlE5AqGyZvHFWwPuuBPjHziTWZHu2xuM', '{\"topics\":[\"topic1\",\"topic2\"]}', '2016-11-05 07:56:55', '2016-11-05 07:56:55'),
	(2, 'Haiooo', '0776002114', '150093', '5peAwwfkYo19sRQTZq21ePMynJrRlTLuTwvxGVoSvLIz4jRVQ830nnflZGv9cUK3', '{\"topics\":[\"topic1\",\"topic2\",\"topic3\",\"topic4\"]}', '2016-11-06 02:27:31', '2016-11-06 02:27:53');

members.sql

CREATE TABLE `members` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `msisdn` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `token` varchar(6) COLLATE utf8_unicode_ci DEFAULT NULL,
  `api_token` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `settings` text COLLATE utf8_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `members_msisdn_unique` (`msisdn`),
  UNIQUE KEY `members_api_token_unique` (`api_token`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

query.php

<?php


class MemberController extends controller {
  
  
  
  public function index() {
    $member = Member::whereRaw('JSON_CONTAINS(settings->"$.topics", \'["topic3"]\')')->get();
    
    return $member;
    
  }
  
}