[TYPO3] Advanced query not advanced enough - part 2

[JoH]

> Try the following cleaned up SQL query. It works fine on my 15,5000
> members system.
>
> -----
> SELECT username
> , usergroup
> , first_name
> , last_name
> FROM fe_users
> WHERE
> 1 = 1
> AND fe_users.disable = 0
> AND fe_users.deleted = 0
> AND FIND_IN_SET('1' , fe_users.usergroup)
> ORDER BY zip
> -----
>
> Look up FIND_IN_SET at http://dev.mysql.com/doc/refman/4.1/en/string-
> functions.html.

The problem here is not to find the best query, but the fact that this query
currently can't be solved using the querygenerator of DB-check/Advanced BE
Searchform.
Although FIND_IN_SET might be a working solution on MySQL, we will have to
find another one for these extensions, since we have to stay DBAL
compatible.

Thanx anyway

Joey

-- 
Wenn man keine Ahnung hat: Einfach mal Fresse halten!
(If you have no clues: simply shut your knob sometimes!)
Dieter Nuhr, German comedian
openBC: http://www.cybercraft.de