Guest Posted May 20, 2003 Share Posted May 20, 2003 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 More sharing options...
Guest Posted June 12, 2003 Share Posted June 12, 2003 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 More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.