PostgreSQL - How to use wildcard in string condition
<p>I have a string: A%A</p>

<p>I want to find all string same start with A%A in database.</p>

<p>Example:</p>

<pre><code>AABCD - false
AABCE - false
AA%BC - true
</code></pre>

<p>I use the sql statement:</p>

<pre><code>Select * from Tabel where Column like 'AA%B%'
</code></pre>

<p>But the result are:</p>

<pre><code>AABCD
AABCE
AA%BC
</code></pre>

<p>Because the string include wildcard '%' and postgres select wrong.</p>

<p>Please suggest me a solution</p>