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?
how do we know that there are any more rows that satisfy that condition?
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.
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