Delete particular users SQL query
 

Hi guys i have duplicate users after importing a phpbb3 forum onto vb.

Now those users are duplicate from what ive seen and have the "imported_" prefix before them.

Could somebody give me a query which i could use to run on the admincp SQL execution section to remove all users with the "imported_" prefix?

Cheers