Title: Admin area post search error.
Last modified: August 18, 2016

---

# Admin area post search error.

 *  [Scott McMillan](https://wordpress.org/support/users/skinnydog/)
 * (@skinnydog)
 * [18 years, 9 months ago](https://wordpress.org/support/topic/admin-area-post-search-error/)
 * Hello,
    I renecently upgraded WP and I am now getting a DB error when using the
   post search feature in the admin area. here is the error:
 * I am using version 4.1.2
 * WordPress database error: [You have an error in your SQL syntax; check the manual
   that corresponds to your MySQL server version for the right syntax to use near‘-
   1’ at line 19]
    SELECT posts.*, CASE WHEN posts.post_title REGEXP ‘all’ THEN 
   1 ELSE 0 END AS keyword_in_title, MATCH ( posts.post_title, posts.post_content)
   AGAINST ( ‘all’ ) AS mysql_score FROM terry_posts as posts WHERE posts.post_date_gmt
   <= ‘2007-08-29 22:31:00’ AND ( posts.post_password = ” ) AND ( posts.post_status
   = ‘static’ OR posts.post_status = ‘publish’ ) AND ( posts.post_title REGEXP ‘
   all’ OR posts.post_content REGEXP ‘all’ ) ORDER BY keyword_in_title DESC, mysql_score
   DESC, posts.post_date DESC LIMIT 0, -1

The topic ‘Admin area post search error.’ is closed to new replies.

## Tags

 * [mysql database error](https://wordpress.org/support/topic-tag/mysql-database-error/)

 * In: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/)
 * 0 replies
 * 1 participant
 * Last reply from: [Scott McMillan](https://wordpress.org/support/users/skinnydog/)
 * Last activity: [18 years, 9 months ago](https://wordpress.org/support/topic/admin-area-post-search-error/)
 * Status: not resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics