[Typo3-dev] Extending the fe_users table

[Rainer Kuhn]

Stig N. Jepsen wrote:
>>>>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'

...but this could help you only if all users would use the same scheme when 
entering their name, but as Juergen stated is real life it's mixed up with 
entries like "firstname surname", "surname firstname" etc. That's what I 
meant with the ordering problem in my initial posting.

Cheers,
Rainer