Hello, I have a table with only ips in it. I want to get all networks the ips belong to:
Example: 123.123.123.1 123.123.132.2 123.123.123.3 1.1.1.4 1.1.1.5 1.1.1.6 12.12.12.1 12.12.12.2 12.12.12.10 The result should be: 123.123.123.0 1.1.1.0 12.12.12.0 Instead of converting on matching row (for example 123.123.123.2) to 123.123.123.0 it can be left as 123.123.123.2 or even can be truncated to 123.123.123 The table is stored on a 3.23.43 mySQL Server. The table type is varchar(15) but this can be changed. Thanks, Alexander Newald --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
