[Solved] MySQL - how do I edit a field without replacing?

Random

Right now I have

UPDATE forum_topics SET topic_title = '[Moved from the old forum] ' & topic_title WHERE forum_id=26 LIMIT 1

UPDATE forum_topics SET topic_title = "[Moved from the old forum] " & topic_title WHERE forum_id=26 LIMIT 1

UPDATE forum_topics SET topic_title = "[Moved from the old forum] " + topic_title WHERE forum_id=26 LIMIT 1

So I have a forum with various topics in it. The forum is forum_id=26. The topic titles are topic_title. I'm going to move them all into another forum but first I want to edit the titles so that people will know where they've come from.

I've like to prefix all the old topic titles with "[Moved from the old forum]".

The methods I've tried above aren't working. Can anyone help?

ethernet

I don't see what the & is doing. Believe SQL uses the keyword AND instead of &. Does this work?

UPDATE forum_topics SET title = '[Moved from the old forum]' WHERE forum_id = 26;

Random

If the value of title is currently "Cool new stuff" then I would like it to now be "[Moved from the old forum]Cool new stuff".

I'm trying to basically make a = a+1 but with text .. if that makes sense ??

Webmonkey

Note sure but try this:

UPDATE forum_topics SET topic_title = CONCAT('[Moved from the old forum] ', topic_title) WHERE forum_id=26 LIMIT 1

Random

That worked Webmonkey, thanks very much!

Webmonkey

You have no ; to seperate the two statements? - Amn't sure if you meant to put both in or not.

Random

You caught me before the edit

I did indeed forget to take the other statement out and only noticed this when pasting the error message here.

Thanks for the help.

Webmonkey

Good stuff