KnowledgeHub
Questions
Tags
Users
Search
Alex Rivera
|
Logout
Edit Question
Title
Body
I'm trying to convert A binary IP to a human-readable IP SELECT HEX( `ip_bin` ) FROM `log_metadata` gives me 4333D26E000000000000000000000000 And SELECT INET_NTOA(0x4333D26E) gives me 67.51.210.110 So I tried: SELECT SUBSTRING( CONVERT(HEX(`ip_bin`), CHAR(32)), 1, 8 ) AS `A` , INET_NTOA( SUBSTRING( CONVERT(HEX(`ip_bin`), CHAR(32)), 1, 8 ) ) AS `B` , INET_NTOA(hex(`ip_bin`)) AS `C` , INET_NTOA(`ip_bin`) AS `D` FROM `log_metadata` But I only get +----------+------------+------------+---------+ | A | B | C | D | +----------+------------+------------+---------+ | 4333D26E | 0.0.16.237 | 0.0.16.237 | 0.0.0.0 | +----------+------------+------------+---------+ Any suggestions?
Tags (comma-separated)
Save Edits
Cancel