Hello I wanted to know in which table is the IP and email anonymous. I searched everywhere

[@robin-w Moderator 6 years, 11 months ago]

they are held in the postmeta table

so taking a topic or reply make a note of the id – in the example below it is 16191.

then go into the postmeta and enter this sql command

SELECT * FROMwp_postmetaWHEREpost_idLIKE '16191'

assuming your table prefix is ‘wp_’

you see entries for both the IP and email

[@fantazma Participant 6 years, 11 months ago]

I have try to query but get 0 results.

I can understand where is the problem

[@robin-w Moderator 6 years, 11 months ago]

You query is at fault, as you should get some results !

Is your site public ?

[@tony910 Participant 6 years, 11 months ago]

thank you its good

[@robin-w Moderator 6 years, 11 months ago]

great – glad you are fixed