WordPress.org

Ready to get started?Download WordPress

Forums

MySQL Wildcard not working (2 posts)

  1. tslice
    Member
    Posted 5 years ago #

    SELECT SQL_CALC_FOUND_ROWS wp_comments.*, wp_posts.post_title, wp_posts.post_name FROM wp_comments INNER JOIN wp_posts ON ( wp_posts.ID = wp_comments.comment_post_ID ) WHERE 1=1 AND wp_comments.comment_content LIKE '%nibh%' AND wp_posts.post_date >= '2009-02-03 00:00:00' AND comment_approved = '1' ORDER BY comment_date DESC LIMIT 0, 5

    The wild card operator is not working, not sure why.

  2. MichaelH
    Member
    Posted 5 years ago #

    If you used that query in phpMyAdmin does it work?

Topic Closed

This topic has been closed to new replies.

About this Topic

Tags

No tags yet.