Remove records from mysql
Posted on 2012-04-02
I have a voting poll database that received some really odd votes, the records show some very strange IPs.
4,546 Guest 455.513.414.406/24 / April 2, 2012 @ 6:11 am
4,547 Guest 540.498.503.183/31 / April 2, 2012 @ 6:11 am
A valid vote looks like this:
4,545 Guest 188.8.131.52 / ###.cable.rogers.com April 2, 2012 @ 6:12 am
So i would like to run a sql query and search for all results that have these strange ip.
1) Can i run a sql command that will display the results of all strange IP addresses ?
2) Is there a REGEX sql command that that will search for invalid ip addresses ?
3) What would be the equiv. DELETE command to get rid of these queries.