MySQL - Sort by IP Address

If you have a column containing ip addresses, sort the ip addresses numerically with:

ORDER BY INET_ATON(ip_address_column)

Comments

Post a Comment

Popular posts from this blog

Linux: Permanent CIFS/SMB mount

I needed to permanently mount a directory on a Windows server that had spaces in the path. I also wanted to use a credentials file so that the remote server username and password would not be in the world readable fstab file. The following was cobbled together from: Mount samba shares with utf8 encoding using cifs and: Mount password protected network folders Create a credentials file (as root) containing the username and password and restrict it's ability to be read by other users (/etc/fstab is world readable). vi /root/.smbcredentials username=someusername password=somepassword Save and exit the file. Change the file permissions to only be readable by root. chmod 600 /root/.smbcredentials Update the fstab file Add the following line to /etc/fstab (spaces are replaced with \040  or the mount will fail) // ip address / c$/Program\040Files/Microsoft\040SQL\040Server/ /var/backups/Server cifs credentials=/root/.smbcredentials,iocharset=utf8,sec=ntlm 0 0 Exit ...
Read more

Debian - Install on BTRFS with Snapper Backups, GRUB-BTRFS and ZRAM

Start the Install Process  Boot the Debian install media Select Advanced Options Run through the installer until you get to "Partition Disks" Create the Partitions Select "Manual" Select the free space you are going to install Debian on Select "Create a new partition". This is the EFI partition Set the size to "512 MB" Change "Use as:" to "EFI System Partition" "Bootable flag:" should be "on" Select "Done setting up the partition" Create a 1GB, ext4 partition for /boot Set "Mount point:" to "/boot" Create another partition with the remaining free space Set "Use as:" to "btrfs journaling file system" Set "Mount point:" to "/" Select "Finish partitioning and write changes to disk" Do not create a swap partition. We are going to use ZRAM. Select "No" to continue Write the changes to disk Create the BTRFS System and Subvol...
Read more

Docker

Sum the size of dangling docker images docker images --format "{{.Size}}" --filter=dangling=true | awk '{sub(/B$/,""); print $1 }' | numfmt --from=iec | awk 'BEGIN {sum=0} {sum=sum+$1} END {printf "%.0f\n", sum}' | numfmt --to=iec
Read more