#14822Group membership defined by MM relation instead of text field.
Description
The usergroup memberships for backend and frontend users is currently defined by a comma separated string stored in a binary data field.
This makes getting users from the DB based on what group they belong to cumbersome and inefficient as it requires using the REGEXP operator (more specifically: SELECT * FROM be_users WHERE usergroup REGEXP ‘(,|^)<group_id>(,|$)’;).<br>Replacing this with a many-to-many relationship in the next major revision of Typo3 would in my eyes be a good thing.</group_id>
(issue imported from #M1203)
Reviews 0
No change resolves or names this issue in its commit message, and no comment links one.