CiviCRM Community Forums (archive)

Hi,

I have a MySQL script that I am running to run to update preferred communication methods for my contacts.  I understand that I have to insert it using CRM_Core_DAO::VALUE_SEPARATOR but am unsure how I can represent this in an UPDATE statement.  Is there a way?

I tried
UPDATE civicrm_contact SET preferred_communication_method=3 WHERE external_identifier='p-5677';but that didn't work - neither did
UPDATE civicrm_contact SET preferred_communication_method=CONCAT(CHAR(000),2,CHAR(000)) WHERE external_identifier='p-5677';
Anyone want to help me out?

Thanks!

This worked for me....
My update was to add the ^A before and after the data this was so I could convert a single select custom data field into a multi.
<code>
 UPDATE `civicrm_value_motivation__contribution__2` SET motivation_tag_4 = concat( '
', `motivation_tag_4` , '
' ) 
</code>
The ' <--apostrophe is key around the left and right field else mysql gives the strangest error.
I also edit the civicrm_custom_field in question and changed the default_value to 

(2 of them)
Then set the single select menu to double in the same record.
After that TRUNCATE TABLE `civicrm_cache`  was key to make it all work.

Thanks Lobo of course since this was all you.