MySQL Forums
Forum List  »  Newbie

Problem with sql statement
Posted by: vanessa vercruysse
Date: March 22, 2005 10:07AM

Hi everyone.

I have found on the internet an sql statement for sorting ip adresse but it doesn't work. It always says there's an error. And i don't know how to solve it.
Here is the statement:

SELECT ipadres
FROM `tblpc`
JOIN IPPatterns
ON ipadres LIKE pattern
order by
CAST(substring(ipadres, s1, l1)as tinyint),
CAST(substring(ipadres, s2, l2)as tinyint),
CAST(substring(ipadres, s3, l3)as tinyint),
CAST(substring(ipadres, s4, l4)as tinyint)

Options: ReplyQuote


Subject
Written By
Posted
Problem with sql statement
March 22, 2005 10:07AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.