Mysql Query : filter with condition
<p>I have a table Orders(OID, OrderType, ODep, ReqUser)</p>

<p>i want to filter like below logic:</p>

<pre><code>SELECT * FROM Orders if  (Ordertype='confidential') filter by ReqUser='$UserID'  else filter by ODep
</code></pre>

<p>i am not sure if it is possible!</p>