[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'
>
> ...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.

That's true. If people don't use the same syntax for entering their
names, then it will be impossible to sort correctly.

/Stig