SQL question

[Kirill N]

Hello,

There's a problem in IPS4 that didn't exist in IPS3 which is that when you remove an emoticon, any post that's ever used it shows a broken image.

What I want to do is to somehow find any occurrence of the emoticon code in the database and replace/remove it. Does anybody know how to do this?

[Pinto]

Maybe a update SQL query 

<code>UPDATE table_name SET Column_name WHERE column_name LIKE ':)'</code>

I could be wrong