Re: Regex first three octets

[Gabe L]

Alfonso Caponi Wrote:
-------------------------------------------------------
> Hi,
>
> I've a column with ip address. How can I extract
> only the first three octets
> (for example 127.0.0)?
>
> select ip from tbl_hosts where ip REGEXP
> '[0-9]{1,3}.[0-9]{1,3}.[0-9]{1,3}';
>
> This query is wrong because extract all four
> octets.
>
> Thank you very much,
> Al


You need to escape the . character since it has meaning in a regular expression.

> select ip from tbl_hosts where ip REGEXP
> '[0-9]{1,3}.[0-9]{1,3}.[0-9]{1,3}';

select ip from tbl_hosts where ip REGEXP
'[0-9]{1,3}\.[0-9]{1,3}\.[0-9]{1,3}';