Best way to compose a where query that matches multiple tag values?


Hi there, i was wondering what the best way is to compose a WHERE clause that matches multiple conditions. I was in the impression that i could solve this using regex pattern but i seem to hit a wall. There is to many data returned in my query…

In my case i have several measurements that have an ‘location_id’ as a value.
When is create a query using a where clause like below i get data back that is not correct. Probably to my misunderstanding on how to use the regex pattern or even it is is possible…

My data is as follows

time                 cpu  location_id
----                 ---- -----------
2017-11-27T07:00:00Z 159  2
2017-11-27T15:00:00Z 154  27
2017-11-27T23:00:00Z 117  7
2017-11-28T07:00:00Z 160  7
2017-11-28T15:00:00Z 167  27
2017-11-28T23:00:00Z 170  27

When i execute a query i only want the locations back with the value of ‘7’.
But when i use a query like below the data from location_id 27 is also returned…

SELECT * FROM “measurement” WHERE location_id =~ /7|2|104|45/;

My goal is that i would like to indicate that the location_id should be in a list of values. Is this even possible with regex? Or should i use AND clauses?