title: How to check if there is a conflict in Day/Room/Start time/End time MySQL
body: <p>So I have a table named tbl_fullsched. <a href="http://i.stack.imgur.com/i6qfr.jpg" rel="nofollow">Here it is</a>. As you can see, there are column named Day, Room, Start and End. They are all Varchar(). I want to compare all the data in this columns and display the data that has conflict. Like for example the "Monday" has two schedule in the same room but the time is conflicting with each other. Please help. Thanks</p>