MultiEnum issue when searching

[wtconseil]

Hi

i have a MultiEnum Attribute with the 3 given values : "foo", "bar", "foo bar"
When doing some research with filter on this multienum : "foo" ...

I have the rows matching "foo" + "foo bar" ...

issue with "string in string" ?

I was expecting to only got "foo" rows

[yuri]

Hi,

Unfortunately searching by multi-enum fields has technical constraints. We didn't want to a search ability but people asked for it. I believe that in future we will improve it.

[wtconseil]

ok :-( i understand.

Do you think that the only workaround would be to have unique Name that won't be substring of others values ?

[yuri]

There are two options.

1. To store all values in separate table. Now they are stored as a Json Array in a single column. We will have better search performance.
2. Keep it stored as a json array and use MySQL functionі like https://dev.mysql.com/doc/refman/5.7...functions.html

[wtconseil]

For option 2, be carefull because all users will have to upgrade to Mysql 5.7 ?