I have all_ip filed that contains all my ips.
now I want to split it to public ip and private ip:
public_ip, private_ip, all_ip:
and when private_ip is null I want to put the value from all_ip in public_ip field.
first I did:
| eval private_ip=if(like(all_ip,"XXXX.%") OR like(all_ip,"XXX.%"),all_ip,null())
and now I need to do (all the rest fill it in public_ip field.
this is possible?