UBB.threads PHP Forum Software Community Forums UBB.threads Version 7/8 Support Complicated SQL query

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, '<','<')

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