SitePoint Sponsor

User Tag List

Results 1 to 4 of 4

Hybrid View

  1. #1
    Web Enthusiast
    Join Date
    Jul 2000
    Location
    Western Massachusetts, USA
    Posts
    1,389
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Query search database

    I'm trying to export the keywords people searched on in my Wordpress website. I'm trying to run a query on the database table "search," in phpMyAdmin. But all I get is the first 3 records (see attached). What am I missing?SQL_query.jpg
    Paul C.
    ClickBasics
    http://www.clickbasics.com

  2. #2
    SQL Consultant gold trophysilver trophybronze trophy
    r937's Avatar
    Join Date
    Jul 2002
    Location
    Toronto, Canada
    Posts
    39,262
    Mentioned
    60 Post(s)
    Tagged
    3 Thread(s)
    how do we know that there are any more rows that satisfy that condition?
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL
    "giving out my real stuffs"

  3. #3
    Web Enthusiast
    Join Date
    Jul 2000
    Location
    Western Massachusetts, USA
    Posts
    1,389
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    The condition is a wild card, and I know from within Wordpress that there are more records. I'm trying to see the records here rather than in Wordpress, so I can print them out.
    Paul C.
    ClickBasics
    http://www.clickbasics.com

  4. #4
    SQL Consultant gold trophysilver trophybronze trophy
    r937's Avatar
    Join Date
    Jul 2002
    Location
    Toronto, Canada
    Posts
    39,262
    Mentioned
    60 Post(s)
    Tagged
    3 Thread(s)
    Quote Originally Posted by paulcj2 View Post
    The condition is a wild card...
    the condition is actually just a NOT NULL condition

    now you need to find out whether phpmyadmin is actually showing them all to you

    please run this --
    Code:
    SELECT COUNT(*) FROM search WHERE search_phrase IS NOT NULL
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL
    "giving out my real stuffs"


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •