Query search database

Databases
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?

2

how do we know that there are any more rows that satisfy that condition?

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.

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