Re: Regex first three octets

[Alfonso Caponi]

William Chiquito Wrote:
-------------------------------------------------------
> Hi alfonso,
>
> An option is:
>
> SELECT LEFT(ip, CHAR_LENGTH(ip) - LOCATE('.',
> REVERSE(ip))) FROM tablename;
>

Thank you very much William.

And to count occurences number too?

A wrong attempt:

SELECT classes,count((LEFT(ip, CHAR_LENGTH(ip) - LOCATE('.', REVERSE(ip))))) as classes FROM tbl_eventi;