title: ERROR 1054 (42S22): Unknown column 'year' in 'where clause'
body: <p>Not sure what's going on with my column name.</p>
  
  <pre><code>mysql&gt; SELECT fullname FROM country WHERE year-independence &gt; 1945;
  ERROR 1054 (42S22): Unknown column 'year' in 'where clause'
  </code></pre>
  
  <p>here is the table Limit 5:  </p>
  
  <pre><code>+----------------------------------------------+
  | code | fullname             | continent     | region                    | area   | year-independence | population | avg-lifespan | avg-GNP   | form-government                              |
  +------+----------------------+---------------+---------------------------+--------+-------------------+------------+--------------+-----------+----------------------------------------------+
  | ABW  | Aruba                | North America | Caribbean                 |    193 |                 0 |     103000 |        78.40 |    828.00 | Nonmetropolitan Territory of The Netherlands |
  | AFG  | Afghanistan          | Asia          | Southern and Central Asia | 652090 |              1919 |   22720000 |        45.90 |   5976.00 | Islamic Emirate                              |
  | AGO  | Angola               | Africa        | Central Africa            | 124670 |              1975 |   12878000 |        38.30 |   6648.00 | Republic                                     |
  | AIA  | Anguilla             | North America | Caribbean                 |     96 |                 0 |       8000 |        76.10 |     63.20 | Dependent Territory of the UK                |
  | ALB  | Albania              | Europe        | Southern Europe           |  28748 |              1912 |    3401200 |        71.60 |   3205.00 | Republic                         
  </code></pre>