musicbrainz=> select * from artist_name where name like '%(%' or name like '%)%' limit 20;
  id  |                       name                        
------+---------------------------------------------------
   54 | P. U. B. (Public Urban Bottle)
  115 | 小西?子（ソフィア)
  365 | 鶴ひろみ(ブルマ)
 1079 | Kork, Manuel (Ve&Fruktan)
 1103 | Milk and Honey (German pop duo)
 2963 | Q (10)
 3122 | 沙倉 楓(CV.中島 愛)
 3284 | Herman Rarebell (grindcore)
 3317 | Kim Larsen (gasolin)
 3400 | Asco (Bunzen)
 3496 | Alf (Thomas Pieper)
 3560 | The Shoetrees (Featuring Jonny Cohen)
 4206 | Moon (27)
 4667 | Jazzamor (feat. Publique)
 4908 | Solas (french band)
 5096 | May'n (Sheryl Nome) / Nakajima Megumi (Ranka Lee)
 5444 | Gotō, Maki; Taisei (Sharan Q)
 6014 | Hua Yanjun (Abing)
 6257 | James Harry (pop music composer)