So I have learned that I haven't been using UNIQUE indexes in my tables like I should have, and now there are many duplicates I must delete. I did my homework on the web and pieced together the following query:
delete from notifications
where dateAdded in (select dateAdded from (
select dateAdded, uID, count(*) cnt
where ( uID <> 0
group by dateAdded, uID
having cnt > 1 ) x
Does my syntax look correct? This should, hopefully, delete all duplicate rows that have the same dateAdded and uID.