contao/test — Issue #2383: Add a FIND_IN_SET() method to the Database library
Author: leofeyer
Created: 2011-11-29 09:34:23+00:00
State: open
Labels: Feature, framework

Add a `FIND_IN_SET()` method to the Database library and use [Andreas Schempp's workaround](http://www.contao-community.de/showthread.php?5950-Wer-liest-mit-im-SVN&p=79636#post79636) for systems which do not support `FIND_IN_SET()`.

```
SELECT * FROM table ORDER BY FIND_IN_SET(language, 'de,fr,en');
SELECT * FROM table ORDER BY language='de' DESC, language='fr' DESC, language='en' DESC;
```

Then remove the `FIND_IN_SET()` workarounds from `DC_Table.php` and `FrontendUser.php`.

--- _Originally created on August 3rd, 2010, at 10:48am (ID 2383)_