[Typo3-dev] Extending the fe_users table

[Stig N. Jepsen]

>>> field and not splitting in firstname/lastname? IMHO this would be
>>> better for ordering and stuff like that.
>>
>> I agree on this one too, though it's still possible to order through
>> mysql, it's just a little more complex.
>
> I think its impossible.

It's not impossible:
'SELECT *,SUBSTRING_INDEX(name,\' \',-1) AS surname FROM fe_users ORDER
BY surname,name'

/Stig