Database Command Query

[opinionswrest]

Hi all,

Prob being a bit thick but does anyone know how in navicat you can replace all info in a certain row that matches what u need replacing example

In extradata for items table the room ads link change from

You must be registered for see links

to

You must be registered for see links

Is there a query can run to replace the habbo.com to customlink.com all in one go saves doing each item individually?

 

[Nigo]

Need more information like the columns etc. but should be something like this:

(You need to change the table name/column & I did not test this so backup your data)

UPDATE `table` SET `column` = REPLACE(`column`, 'https://habbo.com', 'https://customlink.com') WHERE `column` LIKE '%https://habbo.com%';

 

[JayC]

Need more information like the columns etc. but should be something like this:

(You need to change the table name/column & I did not test this so backup your data)

UPDATE `table` SET `column` = REPLACE(`column`, 'https://habbo.com', 'https://customlink.com') WHERE `column` LIKE '%https://habbo.com%';

No, He's looking to replace the text "habbo.com" with "customlink.com" in the items table extradata column.

 

[smg]

update items set extradata = '

You must be registered for see links

' WHERE extradata = '

You must be registered for see links

'

would work