Blob field update?

Question

MySQL

Good afternoon! There is a database with a field of type blob. One of the records stores the data I need and I want this data to be in all records of this field.

How can I make sure that all records have the same values ​​for this field? I tried the usual Update table_name set column_name=value_in_blob , which did not help.
I would be grateful for help

Answer 1

If I understand correctly, then something like this (substitute your own table name, columns):

UPDATE table
SET
[blob] = (SELECT [blob] FROM table WHERE id = 555)
WHERE id != 555