:::::::::Вот так:::::::::
~~~~------------~~~~
UPDATE table
SET field = field & 'str '
~~~~------------~~~~