Search in mysql column against provided json value <p>I have a table contents. Columns -> id, title, description.</p> <pre><code> CREATE TABLE IF NOT EXISTS `contents` ( `id` int(10) NOT NULL AUTO_INCREMENT, `title` varchar(255) DEFAULT NULL, `description` text, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; </code></pre> <p>-- Dumping data for table <code>contents</code>--</p> <pre><code>INSERT INTO `contents` (`id`, `title`, `description`) VALUES (1, 'My fab phone', 'I own an iphone 5c.'), (2, 'I hate my phone', 'I have a Samsung S4. :('); </code></pre> <p>I have a json vaue made by input from user. Its like -> </p> <pre><code>[{"devices":"iPhone 5c"},{"devices":"Samsung S4"}] </code></pre> <p>I would like to search against it against the title, description comlumn in mysql.. my application is in php. is it even possible in mysql ? or I have to manipulate the json run it in loop and then simple search in mysql ? ...If its possible in mysql then please help</p>