What would be the SQL query for replacing &lt; and &gt; in ubbt_USER_PROFILE > USER_SIGNATURE and ubbt_USER_PROFILE > USER_DEFAULT_SIGNATURE with respectively < and >

?

You'd want to do a database backup on this before hand just in case it causes any problems, but something like this *should* work:

UPDATE ubbt_USER_PROFILE SET USER_SIGNATURE = REPLACE(USER_SIGNATURE, '&lt;','<')

UPDATE ubbt_USER_PROFILE SET USER_DEFAULT_SIGNATURE = REPLACE(USER_DEFAULT_SIGNATURE, 'glt;','>')

Thank you Rick!

That worked.

I need these to regularly fix the signatures on our forums (their URLs contain a "?php" phrase, as they are dynamic). The sigs are turned into plain text as soon as users try to update their profiles.

I guess I have to store these as two separate SQL Queries right? I can't just paste both lines in the Control Panel's SQL Query window at once, right? As for now I have just entered and executed them one by one.

Unfortunately the &lt;/&gt; are stored as </> as soon as you try to store the queries. I have stored them anyway, so that I can copy/paste and then edit them for future use

Since they are both working on the same table you can try doing them as one query like:

UPDATE ubbt_USER_PROFILE
SET USER_SIGNATURE = REPLACE(USER_SIGNATURE, '&lt;','<'),
USER_DEFAULT_SIGNATURE = REPLACE(USER_DEFAULT_SIGNATURE, 'glt;','>')

Thank you Rick!

There were a few errors in that, but I got the idea:

UPDATE ubbt_USER_PROFILE SET USER_SIGNATURE = REPLACE(USER_SIGNATURE, '&lt;','<'), USER_DEFAULT_SIGNATURE = REPLACE(USER_DEFAULT_SIGNATURE, '&gt;','>')

Thanks a lot!