Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

mysql query help


Guest

Recommended Posts

Hello,

 

I need to update a MEDIUMTEXT field in my database and I have used

 

set field1 = field1+1 for numeric fields,

 

but what do you do to add text to the end of the text field?

 

you can't use the same syntax for tecxt fields as you would for numeric

 

Any ideas?

Link to comment
Share on other sites

  • 4 weeks later...

For the sake of all I will answer my own question.

 

If you need to add text to a char. field use

 

CONCAT(field_name, 'new text');

 

 

Thanks to MB...

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...