Question and answer is powered by AnsPress.io
I have two column current_stock and stock_alert in my MySQL table. I want select rows while current_stock grater than 0 and stock_alert gater than current_stock.
How can I select data?
Apply this code:
SELECT * FROM table WHERE `current_stock` > 0 and `stock_alert` >= `current_stock`