title: MySQL: How to get all values in "TICKER" column`?
body: <p>I never used SQL before, I want to get all values in "TICKER" from this database:</p>
  
  <p><img src="https://i.stack.imgur.com/4Rxl1.png" alt="enter image description here"></p>
  
  <p>The first statement </p>
  
  <p><code>select TDATE, price, return1 from STOCK_DATA where TDATE &lt; 20131231 and TDATE &gt; 20121231 and TICKER = 'IBM'</code> </p>
  
  <p>works fine for a single 'IBM' ticker.</p>
  
  <p>However, I want to have the list of all tickers in this table, but <code>select TICKER from STOCK_DATA</code> does not work?</p>