Filter where? Please be more specific as to what your issue is. I also don't know what "Figurant" or "Edelfigurant" is, sorry.

But the problem however is that when they select figurant, edelfigurant will show up as well on the result page.

edelfigurant contains figurant. That's going to be a problem for searching as in most cases it will use LIKE in the SQL with a wildcard. Especially for multi-checkbox or multi-select fields since they're stored as VALUE_1|*|VALUE_2 in the database. You need to be sure to always use a generic Value that is separate from the Label when configuring your select fields. Example as follows.

Valid Select Options
Value: Opt_1
Label: figurant
Value: Opt_2
Label: edelfigurant

Invalid Select Options
Value: figurant
Value: edelfigurant

The second usage will cause issues. The stored and displayed value are one in the same. Any LIKE based SQL searching will cause the first option to return also the second option because the second option contains the value of the first option. The first usage does not have this problem since the stored values (not seen by the user) are generic, but you can still hit issues with this if not careful (e.g. Opt_1 is within Opt_10). This only impacts fields that allow selecting multiple values (e.g. multi-select or multi-checkbox).

Changing the value will not automatically change it for every user. You'd have to manually fix that within your database. Example of how to best do that using SQL.


Replace jos_ with whatever your database prefix is and replace FIELD_NAME with your fields name (e.g. cb_myfield). Be sure to make a backup before doing this. The above will first replace Edelfigurant with Opt_02 then replace Figurant with Opt_01. You can change the Opt_02 and Opt_01 to whatever you like as they're just examples.