I have a table with a column named tags. In this column, I have a comma-separated list like air conditioner, tv, fridge. I want to check if any of the words in the comma-separated column exists in a string like…
I've got an older table where some IDs are stored in a varchar as comma separated list. name street some_ids Pete Teststr 3,4,7,2 Tom Teststr 1,4,7,3 Inga Teststr 3,7,2,5 I.e. need to find the entries containing 2 in column "some_ids"…
Since MySQL version 8.0.17 there is Multi-Valued Indexes for JSON array column, is there also a simple possibility to create Multi-Valued Indexes for comma delimited string column (CHAR, VARCHAR, ...) to increase the performance of FIND_IN_SET function? I know that…
Table "skus": plant_species_ids 1,2,3,2,3,1 Table "plant_species" id name 1 Plant 1 2 Plant 2 3 Plant 3 The relevant part of my MySQL code: ... GROUP_CONCAT(plant_species.name SEPARATOR ', ') as plant_species_names ... LEFT JOIN plant_species ON FIND_IN_SET(plant_species.id, skus.plant_species_ids) > 0…