I never found a good way to index multiple fields of one row as entries of an index or simulate this feature on MySQL.
The problem arises when you have fields working as tags or similar concept. Ex.: fields names as tag1, tag2, tag3. To search lines with a specific tag fast requires that you have 3 index and do 3 separate queries on the most basic and obvious way.
Is there any way to index these 3 fields as entries of one index allowing just one search.
ID tag1 tag2 tag3 -- ---- ---- ---- 01 abc xyz bla 02 foo bar ble 03 xyz bla bar index abc -> 01 bar -> 02 03 bla -> 01 03 ble -> 02 foo -> 02 xyz -> 01 03
Or is there any other way to do this efficiently?