Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT (case when (<condition to match first octet>) then IPPARSED else END) as 1,
- (case when (<condition to match second octet>) then IPPARSED else END) as 2,
- (case when (<condition to match third octet>) then IPPARSED else END) as 3,
- (case when (<condition to match fourth octet>) then IPPARSED else END) as 4
- FROM <insert_table_name_or_table_definition_here>
Add Comment
Please, Sign In to add comment