如果条件满足，如何删除MySQL中的行

I have rows with a column called Flags and I want to delete a certain row when the number of flags reaches 100 in that column. I have rows with a column called Flags and I wa