[Typo3-dev] Sorting without "ORDER BY sorting"

[Ingo Schmitt]

Hi

> Hi guys,
> 
> I need to sort extension tables without being able to use "sorting".
> so basically I select and ORDER BY title.
> But I have several DVD series and this results in something like this:
> 
> Godzilla 1
> Godzilla 10
> Godzilla 2
> ...
> 
You can do this via mysql too...

select DVDTIITLE, SUBSTRING_INDEX(DVDTITLE,' ',1) as name, 
SUBSTRING_INDEX(DVDTITLE,' ',-1) as series from table order by name, series

(see :http://dev.mysql.com/doc/mysql/en/String_functions.html)

> Any idea, how I can sort thing correctly?
> 
Ingo

Mit freundlichen Gruessen
-- 
Ingo Schmitt                        mailto:is at marketing-factory.de
Marketing Factory Consulting GmbH   http://typo3.marketing-factory.de/
Content Management mit Typo3: Beratung - Schulung - Realisierung