Given an example dataset I'm trying to sort through:

```
email,domain_name
name1@email.com,superlorem.com
name2@email.com,superdolor.com
name3@email.com,superamet.com
name4@email.com,badlorem.com
name5@email.com,baddolor.com
name6@email.com,badamet.com

```

And I'm starting off with a query such as...
 SELECT email
 FROM table
 WHERE 
 (domain\_name contains 'dolor') or
 (domain\_name contains 'sit') or
 (domain\_name contains 'amet')
 GROUP BY email

Is it possible to group results by the "contains" word, such as 'dolor', 'sit', and 'amet'? The words wouldn't exist by themselves in a column (Such as being part of a domain name, superlipsum.com for example). My end goal is to have a CSV that resembles this:

```
Dolor,column1
Dolor,column2
Dolor,column3
Sit,column4
Sit,column5
Sit,column6
Sit,column7    
Amet,column8

```