<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"
"http://www.w3.org/TR/REC-html40/loose.dtd">
<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=utf-8">
<title></title>
</head>
<body style="font-family:Arial;font-size:14px">
<p>In the case that the task is to select all records from mytable where the full_address contains the string pao_text, the like clause is probably much more efficient:<br>
<br>
<span style="font-family:courier new,courier,monospace;">select * from mytable where full_address like '%pao_text%';</span><br>
<br>
Performance might not be an issue here but it is never bad to have an eye on efficiency in my opinion.<br>
<br>
Cheers<br>
<br>
Thiemo<br>
<br>
Quoting Bo Victor Thomsen <<a href="mailto:bo.victor.thomsen@gmail.com">bo.victor.thomsen@gmail.com</a>>:</p>
<blockquote style="border-left:2px solid blue;margin-left:2px;padding-left:12px;" type="cite">
<p>select * from mytable where full_address ~* <b>'</b>pao_text<b>'</b>;<br>
^ ^</p>
<p>You've forgotten the string delimiters</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:</div>
<blockquote cite="mid:CA+i5JwYnPbLbMh2V7L9rkX4ke4SD=OVJGi-j6cpPs8=E4b47Qw@mail.gmail.com" type="cite">
<p>select * from mytable where full_address ~* pao_text;</p>
</blockquote>
</blockquote>
<p><br>
<br></p>
<div>S/MIME Public Key: <a href="https://oc.gelassene-pferde.biz/index.php/s/eJuAUFONag6ofnH" target="_blank">https://oc.gelassene-pferde.biz/index.php/s/eJuAUFONag6ofnH</a><br>
Signal (Safer than WhatsApp): +49 1578 7723737<br>
Threema (Safer than WhatsApp): A76MKH3J<br>
Handys: +41 78 947 36 21 | +49 1578 772 37 37</div>
</body>
</html>