What do you mean with filter?

Something like this?

DELETE FROM myTable WHERE columnA = 'B'

ps: why define a VARCHAR(1) column? What is wrong with CHAR(1). If you do have millions of rows, you're literally throwing storage away!