mysql append to blob?

[safra]

Hi,

I can't figure out how to add a string to the current contents of a blob in mysql.

Anyone can help me with this?

Thanks, Raoul

[LordShryku]

A regular update statement should do it...

[safra]

Yes, I thought it shouldn't be a problem, but I can't get it to work. I tried:

UPDATE profiles SET authMem = authMem AND '-$add-' WHERE username='$username'

and

UPDATE profiles SET authMem = authMem + '-$add-' WHERE username='$username'

(where authMem is the blob)

Both attempts failed.

[LordShryku]

Try concat'ing.

[safra]

Thanks! I had to search a bit for information about concat() but found it and it works!