How to use regex in where

[wartw]

How to use regex in where
I need to output all IP addresses containing pppoe_network card

[EvilFreelancer]

Hi! Operator ~ (like) can be used for filtering, you may try something like this:

$query->where('address', '~', 'pppoe_network');

UPD. I'm not sure if it's PCRE compatible, see this and this for details.