Author Topic: Capitalising Last and First and getting Sort name and Display Name to update (Read 3593 times)

jimmyjam · October 21, 2010, 10:06:41 pm

I upgraded MySQL to version 5.1.51, and ran this SQL statement:

UPDATE civicrm_contact set sort_name = CONCAT_WS (', ', last_name, first_name) 
WHERE contact_type LIKE 'Individual' 
AND last_name IS NOT NULL;

It worked beautifully. Thanks again, Peter.

-James

petednz · October 22, 2010, 02:20:47 am

great - glad it helped

petednz · November 05, 2010, 05:00:05 pm

seems the issue is that some mysql versions don't permit a 'space' after the function name - hence try

UPDATE civicrm_contact set sort_name = CONCAT_WS(' ,', last_name, first_name) where sort_name like '%@%' and last_name is not null

CiviCRM Community Forums (archive)