title: get column name by mysql intersect equivalent
body: <p>I have the following structure for a table what i want is MySQL query equivalent to this query: </p>
  
  <pre><code> SELECT column_name
      FROM information_schema.columns
      WHERE table_name = 'table_name'
          AND company = '77'
          AND columns IS NOT NULL OR columns IS NOT = 0
      INTERSECT
      SELECT column_name
      FROM information_schema.columns
      WHERE table_name = 'table_name'
          AND company = '799'
          AND columns IS NOT NULL OR columns IS NOT = 0
      INTERSECT
      SELECT column_name
      FROM information_schema.columns
      WHERE table_name = 'table_name'
          AND company = '700'
          AND columns IS NOT NULL OR columns IS NOT = 0
      INTERSECT
      SELECT column_name
      FROM information_schema.columns
      WHERE table_name = 'table_name'
          AND company = '788'
          AND columns IS NOT NULL OR columns IS NOT = 0
  </code></pre>
  
  <blockquote>
    <p>calling_numb
    |called_num|cell_id|calling_loc|called_loc|company|cell_type|called_reg
    |c_site</p>
    
    <p>+937779832423|+93799234323|C8435|   NULL    | NULL     | 77    | Nokia   | 44       |443543</p>
    
    <p>+937883432424|+93700335234|S6700| 4         |  9       | 788   | 435341  | NULL     | NULL</p>
    
    <p>+937999343324|+93788324234|W580 | Ghazni    |   Herat  | 799   | Kabul   | NULL     | NULL</p>
    
    <p>+937003556322|+93788342343|K860 | 01        |   NULL   | 700   | NULL    | NULL     | 6823</p>
    
    <p>+937778342453|+93700453423|L900 | 05        | 12       | 77    | Samsung | NULL     | NULL</p>
    
    <p>+937994354356|+93789345435|K334 | Ghazni    | Herat    | 799   | Nokia   | NULL     | 3345</p>
    
    <p>+937004353455|+93799033453|S6790| NULL      | NULL     | 700   | NULL    | xYZ      |34543</p>
  </blockquote>