Hello Kirupans!
I have a question about writing a particular query in MySQL. I have a data field that is a SET data type called prodEnv, and I have four possible values (‘outdoor’, ‘indoor’, ‘fixed’, ‘mobile’). All of my entries use more than one of those values, like maybe ‘indoor’ and ‘mobile’.
My question is, how do I write a query for all entries that contain any one of those given values, even if it has multiple values?
My current query is:
SELECT * FROM `wi4_apcpe` WHERE `**prodEnv**` = "**outdoor**"
But that will not return any entries…
Any help would be greatly appreciated! Thanks in advance.
