Member Avatar for magicmarkuk

Hi

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?

Thanks
Mark

  • 2 Contributors
  • 2 Replies
  • 133 Views
  • 7 Hours Discussion Span
  • Latest Post Latest Post by magicmarkuk

Recommended Answers

All 2 Replies

Member Avatar for jlego

CONCAT('RE: ', Title) as The_Title

Edited by jlego because: n/a
Member Avatar for magicmarkuk

Thank you very much - works perfectly :)

Be a part of the DaniWeb community

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