MySQL how to get start and end of last week given date from day of next (last) week?

Question

MySQL

I found the solution :)
we have a datetime `time` field in which a certain date is stored, and so the solution:
select TIMESTAMPADD(DAY,-WEEKDAY(`time`)-7,DATE(`time`)) as `WeekStart`,TIMESTAMPADD(DAY,6-WEEKDAY(`time`)-7,DATE(`time`)) as `WeekEnd` from ..
at the output we get WeekStart and WeekEnd with the beginning and end of the week,
"-7" respectively to get the previous one