query problem

[liamoco]

I have a field called 'ext_chats', an example of what will be in the field is...

 

domain1-qwerty,domain2-abcdef,domain3-12345

 

I want to select all from the table if 'qwerty' is in this field. How can this be done?

 

Thanks

[Pikachu2000]

That looks like a poor database structure, but notwithstanding that,

 

SELECT `whatever` FROM `table` WHERE `some_field` LIKE '%qwerty%'
[code]