SOOP colums can sometimes have two SOOPs listed.

[hayesla]

Describe the bug

the SOOP names can sometimes not be unique in the database or files, they sometimes can be listed like:
'L_BOTH_HRES_HCAD_Major-Flare;R_SMALL_HRES_HCAD_RS-burst',
hence if you do a search of

a.soar.SOOP('L_BOTH_HRES_HCAD_Major-Flare') in this case, it will not be returned.

We should check something like

if L_BOTH_HRES_HCAD_Major-Flare in soop_name or something. Need to check how the SOAR does this from their button

To Reproduce

import sunpy

sunpy.map.Map(...)
etc

Screenshots

No response

System Details

No response

Installation method

No response

[samaloney]

A minimal code example would be helpful. I'm not sure ADQL supports IN for substrings so would have to use LIKE e.g. WHERE soop_name LIKE 'L_BOTH_HRES_HCAD_Major-Flare' and add more multiple ones multiple soops or filter after running a query.