I have looked all over the internet and have found what I believe is outdated ways to go about this. I have the latest version of SQL and I just want to know how to get the date of the Monday of the current week via query.
I think the simplest way is
select curdate() - interval weekday(curdate()) day;
Here is a SQL Fiddle.