Linux
From Wiki
Linux Network Tricks
Connecting to two networks - one Wi-Fi and one wired
Wi-Fi network has internet, wired does not. Then, disable the gateway of the Wired network for internet access.
Show the networks
$ ip route show
Smaller metric number means higher priority for the gateway
Remove the gateway of the wired network
$ sudo ip route del default via 192.168.1.1