select query not work for get column using id <p>i want to select row where <code>driverid=903"</code> and get column which date is lessthen or equal to my date see screen shots </p> <p><a href="https://i.stack.imgur.com/grNJ5.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/grNJ5.png" alt=""></a></p> <p><a href="https://i.stack.imgur.com/rTpr5.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/rTpr5.png" alt=""></a></p> <p>but query return me all columns what do i do? help me </p> <pre><code>SELECT * FROM driverlisence WHERE driverid='903' OR motexpiry &lt;='2014/04/12' OR mot2expiry &lt;='2014/04/12' OR PHCVEHICLEEXPIRY &lt;='2014/04/12' OR insurancexpiry &lt;='2014/04/12' OR phcdriverexpiry &lt;='2014/04/12' OR licenseexpiry &lt;='2014/04/12' </code></pre>