Calculate subnet from IP Address and Mask using mysql query
<p>Is it possible to calculate the subnet if I have a IP address and mask using MySQL? I know to do this in PHP, but I am looking for a way to do this in MySQL.</p>
<p>For example, given the IP address 10.196.73.249/29 I'd like to return the network address of 10.196.73.248.</p>