Security

 View Only

custom SQL query

This thread has been viewed 8 times
  • 1.  custom SQL query

    Posted May 05, 2016 06:20 AM

    Hi community,

     

    Have anybody experiance with embedded regexp in pgsql query?
    I would like make a query that matches on the MAC addresses, but I don't know how I can insert the regexp in to the SQL query. eg.:

     

    SELECT * FROM tab WHERE pattern LIKE '{MAC regexp}';

     

    This query doesn't work for me.

    Can anyboy help for me?