XF 2.0 Bulk Delete Smilies in XF2

[Chromaniac]

TRUNCATE TABLE xf_smilie; is mentioned to remove all smilies for XF1.x.
Just curious if this would work in XF2.
I imported quite a lot of smilies in XF1 which I want to remove now as emojis are finally supported.
Logically, I would prefer to keep the ones included with XF2 as they would cover most manually inserted smilies like :) :D. I assume they would come back when I install a future update?

 

[Lamp]

Modifying the database worked for me:
DELETE FROM `xf_smilie` WHERE `image_url` = 'https://f.cl.ly/items/1Y1f1K1i3v3L3l0S0s1N/emoji.png';
I had a ton of smilies with the same image_url that I wanted to delete

 

[Dadparvar]

If you used the add-on that someone posted, that add-on was adding a lot of smilies in different categories.

If so, then you can simply delete the smilies based on their categories using this query:

DELETE FROM `xf_smilie` WHERE `smilie_category_id` = x

Replace the x with any category id of the smilies, and it will delete all the smilies of that category.