Title: starting_with does not work properly
Last modified: August 31, 2016

---

# starting_with does not work properly

 *  [dkarts](https://wordpress.org/support/users/dkarts/)
 * (@dkarts)
 * [10 years, 1 month ago](https://wordpress.org/support/topic/starting_with-does-not-work-properly/)
 * Hello to the developers!
 * First, let me thank yopu for the great plugin. I used it serveral times on my
   pages. Without any problems.
 * Now I want to use the starting_with function of the shortcode.
 * So I created this.
    `[catlist id=2 orderby=title order=asc starting_with=V]`
 * Till the starting_with everything works great. All posts were displayed correctly
   without any problems.
 * Using google does not help either. I found a topic were the collation of DB was
   a problem.
    [Link to the topic](https://wordpress.org/support/topic/starting_with-not-working-but-i-found-a-solution)
   Referring to the post I changed the code in lcp-parameters.php without any success
 * Maybe someone can help with that. Thanks to all in advance.
 * [https://wordpress.org/plugins/list-category-posts/](https://wordpress.org/plugins/list-category-posts/)

Viewing 1 replies (of 1 total)

 *  [borisj](https://wordpress.org/support/users/borisj/)
 * (@borisj)
 * [10 years ago](https://wordpress.org/support/topic/starting_with-does-not-work-properly/#post-7369528)
 * You may get the message
 * WordPress database error: [Unknown column ‘wp_posts.post_title’ in ‘where clause’]
 * on the top of your page?
 * Then you have set a different database table prefix than the regular “wp_…” one.
 * To fix this go to …/plugins/list-category-posts/include/lcp-parameters.php and
   change wp_ to the database table prefix you are using in the following lines.
 * 181 $where .= ‘AND (wp_posts.post_title ‘ .
    184 $where .= ‘OR wp_posts.post_title‘.

Viewing 1 replies (of 1 total)

The topic ‘starting_with does not work properly’ is closed to new replies.

 * ![](https://ps.w.org/list-category-posts/assets/icon-256x256.png?rev=2517221)
 * [List category posts](https://wordpress.org/plugins/list-category-posts/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/list-category-posts/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/list-category-posts/)
 * [Active Topics](https://wordpress.org/support/plugin/list-category-posts/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/list-category-posts/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/list-category-posts/reviews/)

 * 1 reply
 * 2 participants
 * Last reply from: [borisj](https://wordpress.org/support/users/borisj/)
 * Last activity: [10 years ago](https://wordpress.org/support/topic/starting_with-does-not-work-properly/#post-7369528)
 * Status: not resolved