MySQL Select a particular data from a row with multiple value-CodePudding

I'm not sure whether this has been asked or not. I have a database where one of the columns has multiple data in a single row. I wonder what should I do if want to see the data with a certain value from those rows.

For example, I want to see the table for the BUILDINGS group only. When I tried to do this:

SELECT **
WHERE groups='BUILDINGS'

there will be no data shown.

What I expect is something like this:

node name   x   y   z   max   groups
   336     ... ... ...  ...    ... 
   340     ... ... ...  ...    ... 
   342     ... ... ...  ...    ...

enter image description here

thanks in advance!

CodePudding user response：

SELECT * from '{your table name}'
WHERE groups like '%BUILDINGS%'

CodePudding user response：

select * from <your table Name> where groups like '%BUILDINGS%';