I am having a bad day!

I am running an INSERT INTO and SELECT query which is working.

One of the SELECT parts is:

(SELECT title FROM exp_forum_topics WHERE topic_id = p.topic_id) AS post_subject,

which brings back a title.

What I want to do is prefix this title with 'Re: ' but my mind has gone completely blank how to do that - can anyone help please?


Recommended Answers

CONCAT('RE: ', Title) as The_Title

Jump to Post

All 2 Replies

CONCAT('RE: ', Title) as The_Title

Thank you very much - works perfectly :)

Be a part of the DaniWeb community

We're a friendly, industry-focused community of 1.21 million developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.