UPDATE tablename SET description=(substring(description for position('test' in
description))||'exam'||substring(description from position('test' in
description)+char_length('test')));
Keep in mind that this will only replace the first occurence of the word 'test' in the
description and that d
is there a way in postgres to change just a part of a text data in a
column. for example if i have a column called description with the
following data:
+-+
| description |
+-+
| this is a test. |
+-+
and i want to change th
