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,%'; _______________________________________________ TYPO3-english mailing list [email protected] http://lists.netfielders.de/cgi-bin/mailman/listinfo/typo3-english
