title: Mysql: How to filter data by using like statement in subquery
body: <p>I've two tables as below, I wanted to filter the values where a word contains in <code>bad_word</code> table</p>
  <p>Bad word Table</p>
  <pre><code>CREATE TABLE `bad_word` (
    `id` int(11) NOT NULL,
    `value` varchar(255) NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8
  
  
   id value
   1  apple
  </code></pre>
  <p>Item table</p>
  <pre><code>CREATE TABLE `items` (
    `id` int(11) NOT NULL,
    `name` varchar(255) NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8
  
  id  name
  1   buy this apple
  2   buy this orrange
  3   buy this mango
  </code></pre>
  <p>I want to get final result after the filter</p>
  <pre><code>id  name
  2   buy this orrange
  3   buy this mango
  </code></pre>
  <p>Sample query I've tried</p>
  <pre><code>select * 
  FROM items 
  where
  items.name not like CONCAT('%', select value from bad_words , '%')
  </code></pre>