how to set from date current date to to date 6 month ago in mysql code example
Example: mysql last 6 months
.... where yourdate_column > DATE_SUB(now(), INTERVAL 6 MONTH)
.... where yourdate_column > DATE_SUB(now(), INTERVAL 6 MONTH)