JQL to select issue with multiple labels based on 1 label

[aaron]

I need a way to select issues that have one or more labels, if any of the labels = x.  For example, I could have one issue with labels of x,y,z and another with x,y and another with x,a and some with a,b, z.y. I just want to select the ones that have x in them. Normally, I would use contains (~), but apparently the labels field doesn't support ~.  

[Hannes Obweger - JXL for Jira · Accepted solution]

Hi @aaron

welcome to the community.

Maybe I'm missing something but wouldn't 

labels in ("x")

give you that?

Best,

- H

[aaron]

You are correct.  

For some reason, I was thinking of "IN" in terms of SQL where the in is a list of values to select, not to be selected. so in jql, "IN"= SQL "Like" without the wildcards.