title: Having issues inside my WHERE clause conditions. <> and AND OR
body: <p>I'm working on a workout generation type of application and I'm having a problem with a mysql query. The problem I'm having is I keep grabbing more than 1 of certain ExerciseIDs when I specifically have them as a Not equal &lt;> in the where clause. </p>
  
  <pre><code>SELECT `Exercise_Name` , `Body_Part_Focus` , `Video_FileName` , `Alignment_Body_Position` ,  `Description_Movement_Technique` , `Tip1_Trainer_Tips` , `Sets` , `Post_Season` , `Off_Season`, `Pre_Season` , `In_Season` , `Measurement_Type` , `Measurement_Type_Label` ,`ExerciseID` 
  FROM `tbl_exercises` WHERE 
  `exrcs_age_approp` = '14 to 17' 
  AND `exrcs_prgssn_lvl` = 'I' OR `exrcs_prgssn_lvl` = 'II' 
  AND `Athletic_Skill` = 'ROM' OR `Exercise_Subskill` = 'ROM' 
  AND `Body_Part_Focus` = 'Torso' 
  AND `ExerciseID` &lt;&gt; 89 
  AND `ExerciseID` &lt;&gt; 58 
  AND `ExerciseID` &lt;&gt; 178 
  AND `ExerciseID` &lt;&gt; 249 
  ORDER BY RAND( ) LIMIT 0 , 1
  </code></pre>
  
  <p>Also am I doing the AND OR clause correct? 
  I'm trying to say THIS AND THIS or THIS AND THIS.. ect.. but I think my mysql might be interpreting that wrong too... I normally don't touch back-end stuff. </p>
  
  <p>Thanks </p>