title: mysql select a,b from y where a=1 and b does not equal blank
body: <p>Just a basic question on syntax an/or if it can be done</p>
  
  <p>How do I select all values from a column that meet certain conditions?</p>
  
  <pre><code>mysql&gt; SELECT l_legs,a_calling_rtcp_mos_fs1 from ims_calls where l_legs=2;
  +--------+------------------------+
  | l_legs | a_calling_rtcp_mos_fs1 |
  +--------+------------------------+
  | 2      | 43                     |
  | 2      | 43                     |
  | 2      | 35                     |
  | 2      |                        |
  | 2      | 43                     |
  | 2      | 43                     |
  | 2      | 43                     |
  | 2      | 10                     |
  | 2      | 10                     |
  | 2      | 43                     |
  +--------+------------------------+
  10 rows in set (0.00 sec)
  </code></pre>
  
  <p>this is my attempt: </p>
  
  <pre><code>mysql&gt; SELECT l_legs,a_calling_rtcp_mos_fs1 from ims_calls where l_legs=2 AND l_legs NOT = "";
  ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '= ""' at line 1
  </code></pre>
  
  <p>what I want is to remove the blank space in the <code>a_calling_rtcp_mos_fs1</code> column from the output, so that I will get 9 rows.</p>