mysql - getting error #1242 while deleting data from the table -

i trying delete data table , query below:

delete mybadge uid=5 , badge_name=(select concat(tag_name,'-beginner') tag,post_tags post_tags.tag_id=tag.tag_id); 

i getting 5 records select statement, want delete 5 records.

use- 'in' keyword instead of '=' sign

delete mybadge uid=5 , badge_name in (select concat(tag_name,'-beginner') tag,post_tags post_tags.tag_id=tag.tag_id);