WordPress: Replace or Purge Text on all Posts by mysql

If you have to remove a link, text or else on all wordpress posts pages with same signs like the „read more“ tag do:

 mysql -u dbadmin -p 

– enter password
– change database by:

use databasename

– run change command(SET „more-tag-source-html-pre“ WordPress reformat the output here! ):

mysql > UPDATE wp_posts SET post_content = REPLACE (post_content,'<!!--more-->',''); 

– System Echo’s:

Query OK, 88 rows affected (0.01 sec)
Rows matched: 706 Changed: 88 Warnings: 0