XF 2.1 Query to replace empty user_field_value

[Mr Lucky]

I want to replace all empty custom user fields with TBC

I have tried this but not working:

UPDATE `xf_user_field_value`
SET `field_value` = replace(field_value, '', 'TBC')

Ideally I would do it for only user field id, is that also possible?

Thanks

 

[Mr Lucky]

Aha, think I got it

UPDATE `xf_user_field_value`
SET `field_value` = 'TBC'
WHERE field_value = ''