SQL Stringfunktionen

[mkinzler]

MySQL mag wohl die Verwendung des Alias in der On-Bedingung nicht

[omata]

SQL-Code:

SELECT j.*, 
       j.time2 - j.time1 AS diff1,
       j.time3 - j.time1 AS diff2,
       bis
FROM (SELECT ip
      FROM data
      GROUP BY ip 
      HAVING COUNT(*) > 1) b
INNER JOIN (SELECT *, CHARACTER_LENGTH(ip) - POSITION('.' IN REVERSE(ip))+1 AS bis
            FROM data) j
  ON SUBSTRING(b.ip FROM 1 FOR bis) = SUBSTRING(j.ip FROM 1 FOR bis)