[RESOLVED] Mysql query not working as supossed

Hello all,

I have this query that im running

SELECT * FROM tickets WHERE DATE_FORMAT(sentdate,'%M') = 'September' AND user='moa' OR user='mike' ORDER BY sentdate ASC

Is not respecting the first condition, it's showing September but also past months, any ideas on why this is not working?

if i remove the "OR user='mike'" works fine...any ideas 🙁

Thanks to all.

Try doing some grouping:

...WHERE DATE_FORMAT(sentdate,'%M') = 'September' AND (user='moa' OR user='mike')

bradgrafelman wrote:
Try doing some grouping:
...WHERE DATE_FORMAT(sentdate,'%M') = 'September' AND (user='moa' OR user='mike')

Thanks a lot bradgrafelman, that worked like a charm 🙂