Wordpress "wpdb->update" - Append Text Value

I am trying to update a table column by appending some text to the existing value in the column.

Basically, I am trying to do something like this:

  $wpdb->update('table_name',
                array('notes' => notes + 'some text here to append'))
               ,array('note_id' => 313)
               );

Is this possible?

I am trying to update a table column by appending some text to the existing value in the column.

Basically, I am trying to do something like this:

  $wpdb->update('table_name',
                array('notes' => notes + 'some text here to append'))
               ,array('note_id' => 313)
               );

Is this possible?

• wpdb

Share Improve this question asked Oct 23, 2019 at 18:18 mannyotrmannyotr 1744 bronze badges

Add a comment  | 

1 Answer 1

Sorted by: Reset to default 1

Short answer: it's not possible.

Long answer: you should try $wpdb->query instead and write a regular SQL query, something like this:

UPDATE table_name SET notes = CONCAT(notes, 'text to append') WHERE note_id = '313'

Please note it's only an example and you should use $wpdb->prepare to also sanitize variables properly.