How can I search for a post title in phpMyAdmin?

Discussion in 'MySQL' started by MindReality, Sep 19, 2012.

0
  1. #1
    How can I search for a post title in phpMyAdmin?

    I am using WordPress.

    How can I search for a post title that contains the word "Medical" in it?

    I went to "wp_posts" in phpMyAdmin and tried to search.

    But I don't know which is the correct search operator to use.
     
    MindReality, Sep 19, 2012 IP
  2. EricBruggema

    EricBruggema Well-Known Member

    Messages:
    1,740
    Likes Received:
    28
    Best Answers:
    13
    Trophy Points:
    175
    #2
    see the button "search"

    SELECT * FROM wp_posts WHERE `title` LIKE '%LOL%'
     
    EricBruggema, Sep 23, 2012 IP
  3. MindReality

    MindReality Well-Known Member

    Messages:
    202
    Likes Received:
    5
    Best Answers:
    0
    Trophy Points:
    105
    #3
    I found out how to do it.

    I just go to my blog database in phpMyAdmin

    Click on search

    Type in my search term.

    Find all words.
     
    MindReality, Sep 23, 2012 IP