SQL query to replace text in threads

UPDATE text SET rawtext = replace(rawtext,  '[testting=123]', '[testing]');

Code (markup):

i have to run sql query under vbulletin something like i posted on above
it works but the problem is =123 represents IDs so each tag have a unique number with it
i want to build query so it can match any number under this "testting" tag

any help please

 

All you need to do here is use the LIKE syntax.

WHERE rawtext LIKE 'testing%'

Code (markup):

The % is the variable, like *

I'd have to think about the full command for a second, but I'd rather you now built it, so as not to blame me if anything goes wrong.

Hope that helps.