how to filter through HTML in PostgreSQL query

Insecure private-key encryption

Is there any danger of my neighbor having my wife's signature?

Should a new user just default to LinearModelFit (vs Fit)

Is .NET Framework 3.5 still needed with a SQL Server 2017 installation to utilize Database Mail?

What is the draw frequency for 3 consecutive games (same players; amateur level)?

Boss asked me to sign a resignation paper without a date on it along with my new contract

How to align the top of the text with the top of a figure produced by tikz in minipage

Is the percentage symbol a constant?

"I showed the monkey himself in the mirror". Why is this sentence grammatical?

Writing dialogues for characters whose first language is not English

Taking an academic pseudonym?

Rigorous justification for non-relativistic QM perturbation theory assumptions?

How to put text above column in minipage?

How can I handle players killing my NPC outside of combat?

How do you get out of your own psychology to write characters?

How do I narratively explain how in-game circumstances do not mechanically allow a PC to instantly kill an NPC?

How can I deduce the power of a capacitor from its datasheet?

Why didn't Tom Riddle take the presence of Fawkes and the Sorting Hat as more of a threat?

Was there a pre-determined arrangement for the division of Germany in case it surrendered before any Soviet forces entered its territory?

Are all power cords made equal?

How do I add a strong "onion flavor" to the biryani (in restaurant style)?

How much light is too much?

Why does alert(0.-5) print -5?

Why is Shelob considered evil?



how to filter through HTML in PostgreSQL query














0















I have a table with a name snapmail_logs.



which has a column body in which I have been saving Email Templates as an HTML. There are a few things included in this body, to determine which email was failed or not.



["<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">n<html xmlns="http://www.w3.org/1999/xhtml" style="font-family: Arial, Helvetica, sans-serif; margin: 0; padding: 0;">n<head>n  <meta name="viewport" content="width=device-width">n  <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">n  <title>Evercam.io</title>n</head>n<body bgcolor="#FFFFFF" style="font-family: Arial, Helvetica, sans-serif; -webkit-font-smoothing: antialiased; -webkit-text-size-adjust: none; width: 100% !important; height: 100%; margin: 0; padding: 0;">n<style type="text/css">n  @media only screen and (max-width: 600px) {n    a[class="btn"] {n      display: block !important; margin-bottom: 10px !important; background-image: none !important; margin-right: 0 !important;n    }n    div[class="column"] {n      width: auto !important; float: none !important;n    }n    table.social div[class="column"] {n      width: auto !important;n    }n  }n  @media only screen and (max-width: 480px){n    .logo{n      max-width:28% !important;n      max-width:175px !important;n    }n  }n</style>n<!-- HEADER -->n<table class="head-wrap" bgcolor="#f5f5f5" style="width: 100%; margin: 0; padding: 0;">n  <tr style="margin: 0; padding: 0;">n    <td style="margin: 0; padding: 0;"></td>n    <td class="header container" style="display: block !important; clear: both !important; margin: 0 auto; padding: 0;">n      <div class="content" style="display: block; margin: 0 auto; padding: 15px;">n        <table bgcolor="#f5f5f5" style="width: 100%; margin: 0; padding: 0;">n          <tr style="margin: 0; padding: 0;text-align:center;">n            <td style="margin: 0; padding: 0;">n              <img src="http://www.evercam.io/img/logo.png" class="logo" style="max-width:28%;max-width:175px; padding-top:10px;margin:0;">n            </td>n          </tr>n        </table>n      </div>n    </td>n    <td style="margin: 0; padding: 0;"></td>n  </tr>n</table>n<!-- /HEADER -->n<!-- BODY -->n<table class="body-wrap" style="font-family: Arial, Helvetica, sans-serif; width: 100%; margin: 0; background-color:#f5f5f5; padding: 0;">n  <tr style="font-family: Arial, Helvetica, sans-serif; margin: 0; padding: 0;"><td style="font-family: Arial, Helvetica, sans-serif; margin: 0; padding: 0;"></td>n    <td class="container" bgcolor="#FFFFFF" style="font-family: Arial, Helvetica, sans-serif; display: block !important; border-radius:3px; clear: both !important; margin: 0 auto; padding: 0;">nn      <div class="content" style="font-family: Arial, Helvetica, sans-serif; display: block; margin: 0 auto; padding: 15px;">n        <table style="font-family: Arial, Helvetica, sans-serif; width: 100%; margin: 0; padding: 0;"><tr style="font-family: Arial, Helvetica, sans-serif; margin: 0; padding: 0;">n          <td style="font-family: Arial, Helvetica, sans-serif; font-weight: normal; font-size: 14px; margin: 0; padding: 0;">nn            <p class="lead" style="line-height: 1.6; margin: 0 0 10px; padding: 0;">Hello, </p>nn            <p style="line-height: 1.6; margin: 0 0 10px; padding: 0;">Here's the snapshot from your camera.</p>n            <br>n<img class='last-snapmail-snapshot' id='everc-fhlcr' src='cid:everc-fhlcr.jpg' alt='Last Snapshot' style='width: 100%; display:block; margin:0 auto;'><br>n          <p style='line-height: 1.6; margin: 0 0 10px; padding: 0;'><b>Evercam PK Office 4K</b> (everc-fhlcr) - See the live view on Evercam by <a style='color:#428bca; text-decoration:none;' href='https://dash.evercam.io/v2/cameras/everc-fhlcr'>clicking here</a></p><br>n            <p style="line-height: 1.6; margin: 0 0 10px; padding: 0;">Thanks,</p><br>n            <p style="line-height: 1.6; margin: 0 0 0px; padding: 0;">The Evercam Team</p>n            <p style="color:#aaaaaa; line-height: 1.0; margin: 0 0 10px; padding: 0;"><a href="#" style="text-decoration:none; color:#aaaaaa;">support@evercam.io</a></p>n            <br>nn            <p><center style="font-size:11px">n              If you want to change your Snapmail settings, <a " <> ..., "1551074758", "junaid@evercam.io", "Your Scheduled SnapMail @ 11:05", #DateTime<2019-02-25 06:06:18Z>, #DateTime<2019-02-25 06:06:18Z>]


Above is a sample data which is saved in the body, and this HTML has a class of .last-snapmail-snapshot which tell email was not failed and another class .failed-camera this tells about failure.



One is basically img tag



<img class='last-snapmail-snapshot' id='everc-fhlcr' src='cid:everc-fhlcr.jpg' alt='Last Snapshot' style='width: 100%; display:block; margin:0 auto;'>


and other one is a span



<span id='iamfailed' class='failed-camera'>Could not retrieve live image from</span>


Camera id is one that in ID, which I want to fetch. There could be multiple img and span tags in one body as well.



Through server side, I can filter this Body and can exract the values of failed and successive camera ids but My problem is I cannot sort them or cannot search them with where clause if I get this out of query.



What I am trying to do is:



Get all_camera_ids (which will be from both classes, last-snapmail-snapshot & failed-camera )
Get Failed Camera Ids (All ids from the class failed-camera )



And most probably Is it possible to do a where a query on that? where you can say, failed_camera_ids like "%junaid%"?



Its totally a new subject for me to parse HTML in PSQL query. I am sorry for such a ambiguis question. any help would be thankful






postgresql regex






share



























    0















    I have a table with a name snapmail_logs.



    which has a column body in which I have been saving Email Templates as an HTML. There are a few things included in this body, to determine which email was failed or not.



    ["<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">n<html xmlns="http://www.w3.org/1999/xhtml" style="font-family: Arial, Helvetica, sans-serif; margin: 0; padding: 0;">n<head>n  <meta name="viewport" content="width=device-width">n  <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">n  <title>Evercam.io</title>n</head>n<body bgcolor="#FFFFFF" style="font-family: Arial, Helvetica, sans-serif; -webkit-font-smoothing: antialiased; -webkit-text-size-adjust: none; width: 100% !important; height: 100%; margin: 0; padding: 0;">n<style type="text/css">n  @media only screen and (max-width: 600px) {n    a[class="btn"] {n      display: block !important; margin-bottom: 10px !important; background-image: none !important; margin-right: 0 !important;n    }n    div[class="column"] {n      width: auto !important; float: none !important;n    }n    table.social div[class="column"] {n      width: auto !important;n    }n  }n  @media only screen and (max-width: 480px){n    .logo{n      max-width:28% !important;n      max-width:175px !important;n    }n  }n</style>n<!-- HEADER -->n<table class="head-wrap" bgcolor="#f5f5f5" style="width: 100%; margin: 0; padding: 0;">n  <tr style="margin: 0; padding: 0;">n    <td style="margin: 0; padding: 0;"></td>n    <td class="header container" style="display: block !important; clear: both !important; margin: 0 auto; padding: 0;">n      <div class="content" style="display: block; margin: 0 auto; padding: 15px;">n        <table bgcolor="#f5f5f5" style="width: 100%; margin: 0; padding: 0;">n          <tr style="margin: 0; padding: 0;text-align:center;">n            <td style="margin: 0; padding: 0;">n              <img src="http://www.evercam.io/img/logo.png" class="logo" style="max-width:28%;max-width:175px; padding-top:10px;margin:0;">n            </td>n          </tr>n        </table>n      </div>n    </td>n    <td style="margin: 0; padding: 0;"></td>n  </tr>n</table>n<!-- /HEADER -->n<!-- BODY -->n<table class="body-wrap" style="font-family: Arial, Helvetica, sans-serif; width: 100%; margin: 0; background-color:#f5f5f5; padding: 0;">n  <tr style="font-family: Arial, Helvetica, sans-serif; margin: 0; padding: 0;"><td style="font-family: Arial, Helvetica, sans-serif; margin: 0; padding: 0;"></td>n    <td class="container" bgcolor="#FFFFFF" style="font-family: Arial, Helvetica, sans-serif; display: block !important; border-radius:3px; clear: both !important; margin: 0 auto; padding: 0;">nn      <div class="content" style="font-family: Arial, Helvetica, sans-serif; display: block; margin: 0 auto; padding: 15px;">n        <table style="font-family: Arial, Helvetica, sans-serif; width: 100%; margin: 0; padding: 0;"><tr style="font-family: Arial, Helvetica, sans-serif; margin: 0; padding: 0;">n          <td style="font-family: Arial, Helvetica, sans-serif; font-weight: normal; font-size: 14px; margin: 0; padding: 0;">nn            <p class="lead" style="line-height: 1.6; margin: 0 0 10px; padding: 0;">Hello, </p>nn            <p style="line-height: 1.6; margin: 0 0 10px; padding: 0;">Here's the snapshot from your camera.</p>n            <br>n<img class='last-snapmail-snapshot' id='everc-fhlcr' src='cid:everc-fhlcr.jpg' alt='Last Snapshot' style='width: 100%; display:block; margin:0 auto;'><br>n          <p style='line-height: 1.6; margin: 0 0 10px; padding: 0;'><b>Evercam PK Office 4K</b> (everc-fhlcr) - See the live view on Evercam by <a style='color:#428bca; text-decoration:none;' href='https://dash.evercam.io/v2/cameras/everc-fhlcr'>clicking here</a></p><br>n            <p style="line-height: 1.6; margin: 0 0 10px; padding: 0;">Thanks,</p><br>n            <p style="line-height: 1.6; margin: 0 0 0px; padding: 0;">The Evercam Team</p>n            <p style="color:#aaaaaa; line-height: 1.0; margin: 0 0 10px; padding: 0;"><a href="#" style="text-decoration:none; color:#aaaaaa;">support@evercam.io</a></p>n            <br>nn            <p><center style="font-size:11px">n              If you want to change your Snapmail settings, <a " <> ..., "1551074758", "junaid@evercam.io", "Your Scheduled SnapMail @ 11:05", #DateTime<2019-02-25 06:06:18Z>, #DateTime<2019-02-25 06:06:18Z>]


    Above is a sample data which is saved in the body, and this HTML has a class of .last-snapmail-snapshot which tell email was not failed and another class .failed-camera this tells about failure.



    One is basically img tag



    <img class='last-snapmail-snapshot' id='everc-fhlcr' src='cid:everc-fhlcr.jpg' alt='Last Snapshot' style='width: 100%; display:block; margin:0 auto;'>


    and other one is a span



    <span id='iamfailed' class='failed-camera'>Could not retrieve live image from</span>


    Camera id is one that in ID, which I want to fetch. There could be multiple img and span tags in one body as well.



    Through server side, I can filter this Body and can exract the values of failed and successive camera ids but My problem is I cannot sort them or cannot search them with where clause if I get this out of query.



    What I am trying to do is:



    Get all_camera_ids (which will be from both classes, last-snapmail-snapshot & failed-camera )
    Get Failed Camera Ids (All ids from the class failed-camera )



    And most probably Is it possible to do a where a query on that? where you can say, failed_camera_ids like "%junaid%"?



    Its totally a new subject for me to parse HTML in PSQL query. I am sorry for such a ambiguis question. any help would be thankful






    postgresql regex






    share

























      0












      0








      0








      I have a table with a name snapmail_logs.



      which has a column body in which I have been saving Email Templates as an HTML. There are a few things included in this body, to determine which email was failed or not.



      ["<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">n<html xmlns="http://www.w3.org/1999/xhtml" style="font-family: Arial, Helvetica, sans-serif; margin: 0; padding: 0;">n<head>n  <meta name="viewport" content="width=device-width">n  <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">n  <title>Evercam.io</title>n</head>n<body bgcolor="#FFFFFF" style="font-family: Arial, Helvetica, sans-serif; -webkit-font-smoothing: antialiased; -webkit-text-size-adjust: none; width: 100% !important; height: 100%; margin: 0; padding: 0;">n<style type="text/css">n  @media only screen and (max-width: 600px) {n    a[class="btn"] {n      display: block !important; margin-bottom: 10px !important; background-image: none !important; margin-right: 0 !important;n    }n    div[class="column"] {n      width: auto !important; float: none !important;n    }n    table.social div[class="column"] {n      width: auto !important;n    }n  }n  @media only screen and (max-width: 480px){n    .logo{n      max-width:28% !important;n      max-width:175px !important;n    }n  }n</style>n<!-- HEADER -->n<table class="head-wrap" bgcolor="#f5f5f5" style="width: 100%; margin: 0; padding: 0;">n  <tr style="margin: 0; padding: 0;">n    <td style="margin: 0; padding: 0;"></td>n    <td class="header container" style="display: block !important; clear: both !important; margin: 0 auto; padding: 0;">n      <div class="content" style="display: block; margin: 0 auto; padding: 15px;">n        <table bgcolor="#f5f5f5" style="width: 100%; margin: 0; padding: 0;">n          <tr style="margin: 0; padding: 0;text-align:center;">n            <td style="margin: 0; padding: 0;">n              <img src="http://www.evercam.io/img/logo.png" class="logo" style="max-width:28%;max-width:175px; padding-top:10px;margin:0;">n            </td>n          </tr>n        </table>n      </div>n    </td>n    <td style="margin: 0; padding: 0;"></td>n  </tr>n</table>n<!-- /HEADER -->n<!-- BODY -->n<table class="body-wrap" style="font-family: Arial, Helvetica, sans-serif; width: 100%; margin: 0; background-color:#f5f5f5; padding: 0;">n  <tr style="font-family: Arial, Helvetica, sans-serif; margin: 0; padding: 0;"><td style="font-family: Arial, Helvetica, sans-serif; margin: 0; padding: 0;"></td>n    <td class="container" bgcolor="#FFFFFF" style="font-family: Arial, Helvetica, sans-serif; display: block !important; border-radius:3px; clear: both !important; margin: 0 auto; padding: 0;">nn      <div class="content" style="font-family: Arial, Helvetica, sans-serif; display: block; margin: 0 auto; padding: 15px;">n        <table style="font-family: Arial, Helvetica, sans-serif; width: 100%; margin: 0; padding: 0;"><tr style="font-family: Arial, Helvetica, sans-serif; margin: 0; padding: 0;">n          <td style="font-family: Arial, Helvetica, sans-serif; font-weight: normal; font-size: 14px; margin: 0; padding: 0;">nn            <p class="lead" style="line-height: 1.6; margin: 0 0 10px; padding: 0;">Hello, </p>nn            <p style="line-height: 1.6; margin: 0 0 10px; padding: 0;">Here's the snapshot from your camera.</p>n            <br>n<img class='last-snapmail-snapshot' id='everc-fhlcr' src='cid:everc-fhlcr.jpg' alt='Last Snapshot' style='width: 100%; display:block; margin:0 auto;'><br>n          <p style='line-height: 1.6; margin: 0 0 10px; padding: 0;'><b>Evercam PK Office 4K</b> (everc-fhlcr) - See the live view on Evercam by <a style='color:#428bca; text-decoration:none;' href='https://dash.evercam.io/v2/cameras/everc-fhlcr'>clicking here</a></p><br>n            <p style="line-height: 1.6; margin: 0 0 10px; padding: 0;">Thanks,</p><br>n            <p style="line-height: 1.6; margin: 0 0 0px; padding: 0;">The Evercam Team</p>n            <p style="color:#aaaaaa; line-height: 1.0; margin: 0 0 10px; padding: 0;"><a href="#" style="text-decoration:none; color:#aaaaaa;">support@evercam.io</a></p>n            <br>nn            <p><center style="font-size:11px">n              If you want to change your Snapmail settings, <a " <> ..., "1551074758", "junaid@evercam.io", "Your Scheduled SnapMail @ 11:05", #DateTime<2019-02-25 06:06:18Z>, #DateTime<2019-02-25 06:06:18Z>]


      Above is a sample data which is saved in the body, and this HTML has a class of .last-snapmail-snapshot which tell email was not failed and another class .failed-camera this tells about failure.



      One is basically img tag



      <img class='last-snapmail-snapshot' id='everc-fhlcr' src='cid:everc-fhlcr.jpg' alt='Last Snapshot' style='width: 100%; display:block; margin:0 auto;'>


      and other one is a span



      <span id='iamfailed' class='failed-camera'>Could not retrieve live image from</span>


      Camera id is one that in ID, which I want to fetch. There could be multiple img and span tags in one body as well.



      Through server side, I can filter this Body and can exract the values of failed and successive camera ids but My problem is I cannot sort them or cannot search them with where clause if I get this out of query.



      What I am trying to do is:



      Get all_camera_ids (which will be from both classes, last-snapmail-snapshot & failed-camera )
      Get Failed Camera Ids (All ids from the class failed-camera )



      And most probably Is it possible to do a where a query on that? where you can say, failed_camera_ids like "%junaid%"?



      Its totally a new subject for me to parse HTML in PSQL query. I am sorry for such a ambiguis question. any help would be thankful






      postgresql regex






      share














      I have a table with a name snapmail_logs.



      which has a column body in which I have been saving Email Templates as an HTML. There are a few things included in this body, to determine which email was failed or not.



      ["<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">n<html xmlns="http://www.w3.org/1999/xhtml" style="font-family: Arial, Helvetica, sans-serif; margin: 0; padding: 0;">n<head>n  <meta name="viewport" content="width=device-width">n  <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">n  <title>Evercam.io</title>n</head>n<body bgcolor="#FFFFFF" style="font-family: Arial, Helvetica, sans-serif; -webkit-font-smoothing: antialiased; -webkit-text-size-adjust: none; width: 100% !important; height: 100%; margin: 0; padding: 0;">n<style type="text/css">n  @media only screen and (max-width: 600px) {n    a[class="btn"] {n      display: block !important; margin-bottom: 10px !important; background-image: none !important; margin-right: 0 !important;n    }n    div[class="column"] {n      width: auto !important; float: none !important;n    }n    table.social div[class="column"] {n      width: auto !important;n    }n  }n  @media only screen and (max-width: 480px){n    .logo{n      max-width:28% !important;n      max-width:175px !important;n    }n  }n</style>n<!-- HEADER -->n<table class="head-wrap" bgcolor="#f5f5f5" style="width: 100%; margin: 0; padding: 0;">n  <tr style="margin: 0; padding: 0;">n    <td style="margin: 0; padding: 0;"></td>n    <td class="header container" style="display: block !important; clear: both !important; margin: 0 auto; padding: 0;">n      <div class="content" style="display: block; margin: 0 auto; padding: 15px;">n        <table bgcolor="#f5f5f5" style="width: 100%; margin: 0; padding: 0;">n          <tr style="margin: 0; padding: 0;text-align:center;">n            <td style="margin: 0; padding: 0;">n              <img src="http://www.evercam.io/img/logo.png" class="logo" style="max-width:28%;max-width:175px; padding-top:10px;margin:0;">n            </td>n          </tr>n        </table>n      </div>n    </td>n    <td style="margin: 0; padding: 0;"></td>n  </tr>n</table>n<!-- /HEADER -->n<!-- BODY -->n<table class="body-wrap" style="font-family: Arial, Helvetica, sans-serif; width: 100%; margin: 0; background-color:#f5f5f5; padding: 0;">n  <tr style="font-family: Arial, Helvetica, sans-serif; margin: 0; padding: 0;"><td style="font-family: Arial, Helvetica, sans-serif; margin: 0; padding: 0;"></td>n    <td class="container" bgcolor="#FFFFFF" style="font-family: Arial, Helvetica, sans-serif; display: block !important; border-radius:3px; clear: both !important; margin: 0 auto; padding: 0;">nn      <div class="content" style="font-family: Arial, Helvetica, sans-serif; display: block; margin: 0 auto; padding: 15px;">n        <table style="font-family: Arial, Helvetica, sans-serif; width: 100%; margin: 0; padding: 0;"><tr style="font-family: Arial, Helvetica, sans-serif; margin: 0; padding: 0;">n          <td style="font-family: Arial, Helvetica, sans-serif; font-weight: normal; font-size: 14px; margin: 0; padding: 0;">nn            <p class="lead" style="line-height: 1.6; margin: 0 0 10px; padding: 0;">Hello, </p>nn            <p style="line-height: 1.6; margin: 0 0 10px; padding: 0;">Here's the snapshot from your camera.</p>n            <br>n<img class='last-snapmail-snapshot' id='everc-fhlcr' src='cid:everc-fhlcr.jpg' alt='Last Snapshot' style='width: 100%; display:block; margin:0 auto;'><br>n          <p style='line-height: 1.6; margin: 0 0 10px; padding: 0;'><b>Evercam PK Office 4K</b> (everc-fhlcr) - See the live view on Evercam by <a style='color:#428bca; text-decoration:none;' href='https://dash.evercam.io/v2/cameras/everc-fhlcr'>clicking here</a></p><br>n            <p style="line-height: 1.6; margin: 0 0 10px; padding: 0;">Thanks,</p><br>n            <p style="line-height: 1.6; margin: 0 0 0px; padding: 0;">The Evercam Team</p>n            <p style="color:#aaaaaa; line-height: 1.0; margin: 0 0 10px; padding: 0;"><a href="#" style="text-decoration:none; color:#aaaaaa;">support@evercam.io</a></p>n            <br>nn            <p><center style="font-size:11px">n              If you want to change your Snapmail settings, <a " <> ..., "1551074758", "junaid@evercam.io", "Your Scheduled SnapMail @ 11:05", #DateTime<2019-02-25 06:06:18Z>, #DateTime<2019-02-25 06:06:18Z>]


      Above is a sample data which is saved in the body, and this HTML has a class of .last-snapmail-snapshot which tell email was not failed and another class .failed-camera this tells about failure.



      One is basically img tag



      <img class='last-snapmail-snapshot' id='everc-fhlcr' src='cid:everc-fhlcr.jpg' alt='Last Snapshot' style='width: 100%; display:block; margin:0 auto;'>


      and other one is a span



      <span id='iamfailed' class='failed-camera'>Could not retrieve live image from</span>


      Camera id is one that in ID, which I want to fetch. There could be multiple img and span tags in one body as well.



      Through server side, I can filter this Body and can exract the values of failed and successive camera ids but My problem is I cannot sort them or cannot search them with where clause if I get this out of query.



      What I am trying to do is:



      Get all_camera_ids (which will be from both classes, last-snapmail-snapshot & failed-camera )
      Get Failed Camera Ids (All ids from the class failed-camera )



      And most probably Is it possible to do a where a query on that? where you can say, failed_camera_ids like "%junaid%"?



      Its totally a new subject for me to parse HTML in PSQL query. I am sorry for such a ambiguis question. any help would be thankful






      postgresql regex




      postgresql regex





      share












      share










      share



      share










      asked 44 secs ago









      Junaid FarooqJunaid Farooq

      14029




      14029






















          0






          active

          oldest

          votes











          Your Answer








          StackExchange.ready(function() {
          var channelOptions = {
          tags: "".split(" "),
          id: "182"
          };
          initTagRenderer("".split(" "), "".split(" "), channelOptions);

          StackExchange.using("externalEditor", function() {
          // Have to fire editor after snippets, if snippets enabled
          if (StackExchange.settings.snippets.snippetsEnabled) {
          StackExchange.using("snippets", function() {
          createEditor();
          });
          }
          else {
          createEditor();
          }
          });

          function createEditor() {
          StackExchange.prepareEditor({
          heartbeatType: 'answer',
          autoActivateHeartbeat: false,
          convertImagesToLinks: false,
          noModals: true,
          showLowRepImageUploadWarning: true,
          reputationToPostImages: null,
          bindNavPrevention: true,
          postfix: "",
          imageUploader: {
          brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
          contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
          allowUrls: true
          },
          onDemand: true,
          discardSelector: ".discard-answer"
          ,immediatelyShowMarkdownHelp:true
          });


          }
          });














          draft saved

          draft discarded


















          StackExchange.ready(
          function () {
          StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fdba.stackexchange.com%2fquestions%2f230637%2fhow-to-filter-through-html-in-postgresql-query%23new-answer', 'question_page');
          }
          );

          Post as a guest















          Required, but never shown

























          0






          active

          oldest

          votes








          0






          active

          oldest

          votes









          active

          oldest

          votes






          active

          oldest

          votes
















          draft saved

          draft discarded




















































          Thanks for contributing an answer to Database Administrators Stack Exchange!


          • Please be sure to answer the question. Provide details and share your research!

          But avoid …



          • Asking for help, clarification, or responding to other answers.

          • Making statements based on opinion; back them up with references or personal experience.


          To learn more, see our tips on writing great answers.




          draft saved


          draft discarded














          StackExchange.ready(
          function () {
          StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fdba.stackexchange.com%2fquestions%2f230637%2fhow-to-filter-through-html-in-postgresql-query%23new-answer', 'question_page');
          }
          );

          Post as a guest















          Required, but never shown





















































          Required, but never shown














          Required, but never shown












          Required, but never shown







          Required, but never shown

































          Required, but never shown














          Required, but never shown












          Required, but never shown







          Required, but never shown







          -

          Popular posts from this blog

          Szabolcs (Ungheria) Altri progetti | Menu di navigazione48°10′14.56″N 21°29′33.14″E /...

          Image
          Comuni della provincia di Szabolcs-Szatmár-Bereg Ungheria2001provincia di Szabolcs-Szatmár-Bereg Szabolcs comune Localizzazione Stato   Ungheria Regione Grande Pianura Settentrionale Provincia Szabolcs-Szatmár-Bereg Territorio Coordinate 48°10′14.56″N 21°29′33.14″E  /  48.17071°N 21.49254°E 48.17071; 21.49254  ( Szabolcs ) Coordinate: 48°10′14.56″N 21°29′33.14″E  /  48.17071°N 21.49254°E 48.17071; 21.49254  ( Szabolcs ) Superficie 5,88 km² Abitanti 425 (2001) Densità 72,28 ab./km² Altre informazioni Cod. postale 4467 Prefisso 42 Fuso orario UTC+1 Codice KSH 19169 Cartografia Szabolcs Sito istituzionale Modifica dati su Wikidata  · Manuale Szabolcs è un comune dell'Ungheria di 425 abitanti (dati 2001). È situato nella provincia di Szabolcs-Szatmár-Bereg. Altri progetti | Altri progetti Wikimedia Commons Wikimedia Commons contiene immagini o altri file su Szabolcs .mw-parser-output
          Read more

          Discografia di Klaus Schulze Indice Album in studio | Album dal vivo | Singoli | Antologie | Colonne...

          Image
          Discografie di artisti tedeschi Voce principale: Klaus Schulze . Discografia di Klaus Schulze Klaus Schulze e Lisa Gerrard durante un concerto Album in studio 56 ↙ Album dal vivo 15 ↙ Raccolte 37 ↙ Singoli 4 ↙ Album video 1 ↙ Colonne sonore 4 ↙ Indice 1 Album in studio 1.1 Solisti 1.1.1 Come Richard Wahnfried 1.2 Collaborazioni 1.2.1 Con Rainer Bloss 1.2.2 Con Rainer Bloss ed Ernst Fuchs 1.2.3 Con Lisa Gerrard 1.2.4 Con Andreas Grosser 1.2.5 Con Pete Namlook 1.2.6 Con Pete Namlook e Bill Laswell 1.2.7 Con Michael Shrieve 1.2.8 Con Solar Moon 1.2.9 Con artisti vari 2 Album dal vivo 3 Singoli 4 Antologie 5 Colonne sonore 6 Videografia 7 Collegamenti musica Album in studio | Solisti | 1972 – Irrlicht 1973 – Cyborg 1974 – Blackdance 1975 – Timewind 1975 – Picture Music 1976 – Moondawn 1977 – Mirage 1978 – "X" 1979 – Dune
          Read more

          How to make inet_server_addr() return localhost in spite of ::1/128RETURN NEXT in Postgres FunctionConnect to...

          Image
          Potential client has a problematic employee I can't work with Can the "Friends" spell be used without making the target hostile? Does it take energy to move something in a circle? Why are carbons of Inositol chiral centers? Count repetitions of an array Which RAF squadrons and aircraft types took part in the bombing of Berlin on the 25th of August 1940? Memory usage: #define vs. static const for uint8_t Broad Strokes - missing letter riddle Why does 0.-5 evaluate to -5? Why is 'diphthong' pronounced the way it is? Why did Luke use his left hand to shoot?
          Read more