Is your YOURLS database getting a bit full of spam links and other crap? You can manually mass/bulk remove all those links by running a simple query on the MySQL database.
DELETE url FROM yourls_url WHERE url LIKE '%keyword%'
You might want to replace DELETE with SELECT, so you can see what you will delete first.
What this code does is: it selects the column ‘url’ from the yourls_url table and it checks if the row ‘url’ contain the keyword you entered. You can also search for the exact url, you should then remove the percentage signs.
If you want to remove all the links in your YOURLS URL shortener which have no clicks, you could run something like this:
DELETE url FROM yourls_url WHERE clicks = 0