MySql concat and quotes

Question

I am trying to do something like this:

<td>style="background:url('myimage.jpg') no-repeat;"> + column + </td>

But I get a MySQL error when trying:

Concat ('<td>style="background:url('myimage.jpg') no-repeat;">', info_text, '</td') as Nicetext

I suppose it is all the quotes that mess things up.

Thanks for all help!

See this article on escaping characters:
http://stackoverflow.com/questions/881194/how-to-escape-special-character-in-mysql — GHC, Mar 08 '13 at 09:59

score 6 · Accepted Answer · answered Mar 08 '13 at 10:01

6

Your strings include quote marks. You will have to escape them. Try something like:

Concat ('<td>style="background:url(\'myimage.jpg\') no-repeat;">', info_text, '</td') as Nicetext

answered Mar 08 '13 at 10:01

SteveP

score 1 · Answer 2 · answered Mar 08 '13 at 09:59

1

You haven't escaped the quotes. Try this :

Concat ('<td>style="background:url(\'myimage.jpg\') no-repeat;">', info_text, '</td') as Nicetext

answered Mar 08 '13 at 09:59

Mohamed Amine

2 Answers2