AccsessQuery->mySQL Query problem

[mrbaseball34]

Trying to convert this Access SQL to mySQL:

select
  Severity, GMTTimestamp, IssueId, IssueName,
  IntruderIp, IntruderName, IntruderPort,
  VictimIp, VictimName, VictimPort,
  ResponseLevel, Parameters_, Count_,
  Packet_Flags
from
  attacklist
order by
 Val(Left([intruderIP],InStr([intruderIP],".")-1)) * 16777216 asc, 
 Val(Mid([intruderIP],InStr([intruderIP],".")+1,  InStr(InStr([intruderIP],".")+1, 
          [intruderIP],".")-InStr([intruderIP],".")-1)) * 65536 asc,
 Val(Mid([intruderIP],InStr(InStr([intruderIP],".")+1, [intruderIP],".")+1,
         InStr(InStr(InStr([intruderIP],".")+1, [intruderIP],".")+1,
         [intruderIP],".")-InStr(InStr([intruderIP],".")+1,[intruderIP],".")-1)) * 256 asc,
 Val(Mid([intruderIP],InStr(InStr(InStr([intruderIP],".")+1, [intruderIP],".")+1,[intruderIP],".")+1)) asc

mySQL version:

select
  Severity, GMTTimestamp, IssueId, IssueName,
  IntruderIp, IntruderName, IntruderPort,
  VictimIp, VictimName, VictimPort,
  ResponseLevel, Parameters_, Count_,
  Packet_Flags
from
  attacklist
order by
 Cast(Left(intruderIP,InStr(intruderIP,'.')-1))AS UNSIGNED) * 16777216 asc, 
 Cast(Mid(intruderIP,InStr(intruderIP,'.')+1,  InStr(InStr(intruderIP,'.')+1, intruderIP,'.')-InStr(intruderIP,'.')-1)) AS UNSIGNED) * 65536 asc,
 Cast(Mid(intruderIP,InStr(InStr(intruderIP,'.')+1, intruderIP,'.')+1, InStr(InStr(InStr(intruderIP,'.')+1, intruderIP,'.')+1, intruderIP,'.')-InStr(InStr(intruderIP,'.')+1,intruderIP,'.')-1) AS UNSIGNED) * 256 asc,
 Cast(Mid(intruderIP,InStr(InStr(InStr(intruderIP,'.')+1, intruderIP,'.')+1,intruderIP,'.')+1) AS UNSIGNED) asc

But getting error near ') AS UNSIGNED ) * 16777216 asc'

What am I doing wrong???

[eoghain]

Well it looks like you have too many closing ) in your first 2 cast functions.

[mrbaseball34]

But, it looks like there are other problems, too that I can not figure out...

[mrbaseball34]

select
Severity, GMTTimestamp, IssueId, IssueName,
IntruderIp, IntruderName, IntruderPort,
VictimIp, VictimName, VictimPort,
ResponseLevel, Parameters, Count,
Packet_Flags
from
attacklist
order by
CAST(SUBSTRING_INDEX(intruderIP, '.', 1) as UNSIGNED) 16777216 asc,
CAST((SUBSTRING_INDEX(SUBSTRING_INDEX(intruderIP, '.', -3), '.', 1)) as UNSIGNED) 65536 asc,
CAST((SUBSTRING_INDEX(SUBSTRING_INDEX(intruderIP, '.', -2), '.', 1)) as UNSIGNED) * 256 asc,
CAST(SUBSTRING_INDEX(intruderIP, '.', -1) as UNSIGNED)

Works like a charm!!!!
What a powerful little function that SUBSTRING_INDEX!!!