
<html>

  <head>

    <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">

  </head>

  <body>

    <p>select * from mytable where full_address ~* <b>'</b>pao_text<b>'</b>;<br>

                                                                               
      ^               ^<br>

    </p>

    <p>You've forgotten the string delimiters <br>

    </p>

    <pre class="moz-signature" cols="72">Med venlig hilsen / Kind regards


Bo Victor Thomsen</pre>

    <div class="moz-cite-prefix">Den 17-12-2020 kl. 11:53 skrev

      Shaozhong SHI:<br>

    </div>

    <blockquote type="cite"

cite="mid:CA+i5JwYnPbLbMh2V7L9rkX4ke4SD=OVJGi-j6cpPs8=E4b47Qw@mail.gmail.com">select

      * from mytable where full_address ~* pao_text;</blockquote>

  </body>

</html>