# Advanced Query to Find Works with No Set Language

**URL:** https://community.metabrainz.org/t/advanced-query-to-find-works-with-no-set-language/641805
**Category:** MusicBrainz
**Tags:** search, language, works
**Created:** [June 17, 2023, 10:38am UTC](https://community.metabrainz.org/t/advanced-query-to-find-works-with-no-set-language/641805 "2023-06-17T10:38:55Z")
**Posts on this page:** 2
**Page:** 1

<div class="post-metadata">

### Author: ![sound.and.vision](https://community.metabrainz.org/user_avatar/community.metabrainz.org/sound.and.vision/32/35417_2.png) [@sound.and.vision](https://community.metabrainz.org/u/sound.and.vision)
#### Post date: [June 17, 2023, 10:38am UTC](https://community.metabrainz.org/t/advanced-query-to-find-works-with-no-set-language/641805/1 "2023-06-17T10:38:55Z")

</div>

I used to be able to run a search query, which I think was type:“song” AND lang:“” to show me all works that are marked as songs that have no set language; just something to do to try and clean up the DB.

That doesn’t seem to work now?

Any ideas what the correct query might be?

---

<div class="post-metadata">

### Author: ![derat](https://community.metabrainz.org/letter_avatar_proxy/v4/letter/d/71c47a/32.png) [@derat](https://community.metabrainz.org/u/derat)
#### Post date: [June 17, 2023, 11:43am UTC](https://community.metabrainz.org/t/advanced-query-to-find-works-with-no-set-language/641805/2 "2023-06-17T11:43:21Z")

</div>

It’s ugly, but this seems to work for me: [https://musicbrainz.org/search?query=-lang%3A%2F[a-z]{3}%2F&type=work&limit=25&method=advanced](https://musicbrainz.org/search?query=-lang%3A%2F%5Ba-z%5D%7B3%7D%2F&type=work&limit=25&method=advanced)

In terms of the form at [https://musicbrainz.org/search](https://musicbrainz.org/search), that’s:

- Query: `-lang:/[a-z]{3}/`
- Type: `Work`
- Search method: `Indexed search with advanced query syntax`

(I couldn’t find any way to search for an unset language code, so I’m negating a regexp for languages consisting of three letters. I always have trouble getting MB’s search to work the way I’d expect, so probably there’s a better way.)
