On Mon, Sep 22, 2008 at 05:59:25PM +0100, Joao Ferreira gmail wrote:
> I'm unable to build a LIKE or SIMILAR TO expression for matching and ip
> address
> 192.168.90.3
> 10.3.2.1
> any help please...
use this regular expression:
'^[0-9]{1,3}(.[0-9]{1,3}){3}$'
warning: do not use "like" or "similar to".
proper way to use it:
select * from table where field ~ '^[0-9]{1,3}(.[0-9]{1,3}){3}$';
this regexp is not 100% fault proof - it will happily return rows like:
'300.999.998.7'
but for most of the cases it should be enough. if you need it to match
only ips, and filter out things like '300.999.999.999' - let me know.
Best regards,
depesz
--
Linkedin: http://www.linkedin.com/in/depesz / blog: http://www.depesz.com/
jid/gtalk: depesz@depesz.com / aim:depeszhdl / skype:depesz_hdl / gg:6749007