I have exported a csv file of my database. The columns with IP addresses are scrambled and I need them to be unscrambled.
As you can see from the attached screenshot the columns related to Creation_IP (column V in screenshot) and lastlogin_ip (column Y is screenshot) are no longer IP addresses after export.
Can you please explain how I can export them so that they are not scrambled?
Just to be clear I am in engine4_users of the database.
Not sure what additional information you desire, but this should do:
SELECT P.user_id, P.email, P.displayname, INET6_NTOA(`creation_ip`) AS Signup_IP_Address, INET6_NTOA(`lastlogin_ip`) AS Last_Login_IP_Address FROM engine4_users P
Prints: user id, e-mail, displayname, signup IP, last login IP
I love you OTAw!!!!! It worked!