paulcj2 — 2014-04-01T11:05:11-04:00 — #1
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?
r937 — 2014-04-01T18:19:40-04:00 — #2
how do we know that there are any more rows that satisfy that condition?
paulcj2 — 2014-04-06T09:54:28-04:00 — #3
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.
r937 — 2014-04-06T12:39:04-04:00 — #4
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 --
SELECT COUNT(*) FROM search WHERE search_phrase IS NOT NULL