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