Help me in constructing a MySql Query to retrieve the rows based on datetime column.
Below are the conditions:
1)The date difference between today and date in that column sholud be =>2 days.
2)If the day of the date in DB column is Thursday/ Friday then the date difference between today and date in that column sholud be =>4 days.

Basically , I want all the rows that 2 days older considering 'Saturday & Sunday' as holidays. :)

Thx in Advance

This is Java forum, not MySql...

Anyway, you can use CURDATE(), DAYOFWEEK(DATE), and ADDDATE(DATE, NUMBER_OF_DAYS) functions to do what you want.