[TYPO3] fe_users(usergroup) index

[Vahan Amirbekyan]

just to let you guys know.
we started using find_in_set() function when working with fe_users(usegroup)
Though mysql does not support functional indexing using it 10 fold 
faster then using like '3,%' or like '%,3,%' or like '%,3'
( for which mysql does not use index anyway )


Vahan Amirbekyan wrote:
> please tell me what type of index should be created on 
> fe_users(usergroup) so that it is used by mysql for selects like:
> select first_name from fe_users where usergroup like '%,3,%';