Title: phpMyAdmin SQL Insert
Last modified: August 20, 2016

---

# phpMyAdmin SQL Insert

 *  [deepak1621](https://wordpress.org/support/users/deepak1621/)
 * (@deepak1621)
 * [14 years, 8 months ago](https://wordpress.org/support/topic/phpmyadmin-sql-insert/)
 * Dear All,
 * Would like to have your guidance on the below issue:
 * Using PHP MyAdmin.. What sql query would I run if I wanted to insert a string
   of text in the beginning of every post on my blog?
 * Thanks in advance.

Viewing 2 replies - 1 through 2 (of 2 total)

 *  [vtxyzzy](https://wordpress.org/support/users/vtxyzzy/)
 * (@vtxyzzy)
 * [14 years, 8 months ago](https://wordpress.org/support/topic/phpmyadmin-sql-insert/#post-2206253)
 * THIS IS DANGEROUS! BACK UP THE DATABASE FIRST!
 * Use this form while testing. Replace the 27 with the ID of a test post.
 *     ```
       UPDATE wp_posts
       SET post_content = CONCAT('some test text to insert ' , post_content)
       WHERE post_type = 'post'
          AND post_status = 'publish'
       and ID = 27
       ```
   
 * Once you are satisfied that it will work, remove the line ‘and ID = 27’.
 *  Thread Starter [deepak1621](https://wordpress.org/support/users/deepak1621/)
 * (@deepak1621)
 * [14 years, 8 months ago](https://wordpress.org/support/topic/phpmyadmin-sql-insert/#post-2206255)
 * Hi Thanks for your reply..I also did something on the same lines..
    I added another
   field to the wp_posts table.
 * `demo_content= CONCAT('text', post_content)`
 * Once I was satisfied with the result, I renamed demo_content to post_content(
   and original post_content to something else).

Viewing 2 replies - 1 through 2 (of 2 total)

The topic ‘phpMyAdmin SQL Insert’ is closed to new replies.

## Tags

 * [phpmyadmin](https://wordpress.org/support/topic-tag/phpmyadmin/)
 * [sql](https://wordpress.org/support/topic-tag/sql/)

 * In: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/)
 * 2 replies
 * 2 participants
 * Last reply from: [deepak1621](https://wordpress.org/support/users/deepak1621/)
 * Last activity: [14 years, 8 months ago](https://wordpress.org/support/topic/phpmyadmin-sql-insert/#post-2206255)
 * Status: not resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics