add text at the end of a BLOB/text field

[dflow]

how can one add text at the end of a BLOB/text field

 

like insert '.<br><br>'

[AyKay47]

concatenate it upon output, post the relevant code.

[dflow]

  Quote

concatenate it upon output, post the relevant code.

I did that before with a php loop,

i was wondering if there is a way to recognize the end of the concatenated textfield to

change and add to the end part inside mysql

example:

TEXT1(<BR> at the end)+TEXT2(<BR> at the end)

 

-->

NEWTEXT(<BR> at the end)

update [table_name] set [NEWTEXT] = replace([NEWTEXT],'[<BR>]','[<BR> New Title]');

 

[AyKay47]

sure, you can use mysql's concat() function to append whatever you want to the field, however, doing this would simply be a waste of memory since it is not needed.

[fenway]

Yeah, that's not what a database engine is for.