How to Delete a Row from a Database Like This?

[Crusadex]

Hello, fake memberships are being created on my website. In the Users table, all email addresses start with the word "tistis." I want to delete all accounts (rows) that start with this word. Which command can I use to do this?