mySQL Query shows syntax error but there is nothing wrong in it
<p>I have form where on somewhere on button click it executes this simple update query.</p>

<pre><code>UPDATE yogaAgeGroup SET 6-15 = 'Yes', 16-20 = 'Yes', 21-25 = 'Yes', 26-30 = 'Yes', 31-35 = 'No', 35+ = 'No' WHERE yogaID = '403050'
</code></pre>

<p>but while running it shows syntax error but I don't think there is any error with this query. Is it because of column name where I used '-' between names? But while inserting records in same table there were no errors. Please help..</p>