title: compare/check two tables data in MySQL
body: <p>I need a little help with check data. I have two table. I want to check if file_name in <code>tableA</code> is included in content in <code>tableB</code>. If not then result is which <code>file_name</code> is this.</p>
  
  <pre><code>select * from tableA;
  | id | file_name
  +---+----------
  |  1 | apple.jpg 
  |  2 | green_apple.jpg
  |  3 | red_apple.jpg
  |  4 | apple1.jpg
  |  5 | apple-juce.jpg
  
  ////////////////////////////////////////////
  
  select * from tableB;
  
  | id |  title   |content 
  +----+----------+--------
  |  1 |  title1  | &lt;img style="border:1px dotted;width:463px;height:611px;margin-left:20px;float:right;padding:3px;" src="image/green_apple.jpg" /&gt;&lt;p&gt;Lorem Ipsum is simply &lt;b&gt;dummy text&lt;/b&gt; of the printing and typesetting industry. &lt;/p&gt;
  |  2 |  title2  | &lt;p&gt;Lorem Ipsum is simply &lt;b&gt;dummy text&lt;/b&gt; of the printing and typesetting industry. &lt;/p&gt;&lt;img style="border:1px dotted;width:463px;" src="image/apple.jpg" /&gt;
  |  3 |  title3  | &lt;img style="border:1px dotted;width:463px;" src="image/apple.jpg" /&gt;&lt;p&gt;Lorem Ipsum is simply &lt;b&gt;dummy text&lt;/b&gt; of the printing and typesetting industry. &lt;/p&gt;&lt;img style="border:1px dotted;width:463px;" src="image/apple.jpg" /&gt;
  |  4 |  title4  | &lt;img style="border:1px dotted;width:463px;" src="image/red_apple.jpg" /&gt;&lt;p&gt;Lorem Ipsum is simply &lt;b&gt;dummy text&lt;/b&gt; of the printing and typesetting industry. &lt;/p&gt;&lt;img style="border:1px dotted;width:463px;" src="image/apple.jpg" /&gt;
  |  5 |  title5  | &lt;p&gt;Lorem Ipsum is simply &lt;b&gt;dummy text&lt;/b&gt; of the printing and typesetting industry. &lt;/p&gt;&lt;img style="border:1px dotted;width:463px;" src="image/apple1.jpg" /&gt;
  </code></pre>