<div>
do you mean something like <br />
SELECT * FROM X WHERE col LIKE 'XX?'<br />
that should result in rows containing 'XX1', 'XXA', ...?<br />
<br />
Then you should use the syntax <br />
<br />
SELECT * FROM X WHERE col LIKE 'XX_'<br />
<br />
where '_' stands for any single character in SQL. 
</div>


<div>
what you mean<br />
X here is &quot;?&quot;??<br />
<br />
and beside then query can i use in a statement?
</div>


<div>
No, <br />
SELECT * FROM author_table WHERE first_name LIKE 'Steph?n';<br />
<br />
would return <br />
<br />
authors with first name Stephen, Stephan, ...
</div>


<div>
can i put example<br />
SELECT * FROM author_table WHERE first_name = ?;<br />
<br />
can i use ? in statement like<br />
a?b?
</div>


<div>
<div class="content wysiwyg-content">
can any one show me some example on how to use metacharacter &quot;?&quot;<br />
<br />

</div>
</div>


can any one show me some example on how to use metacharacter "?"



metacharacter ?

PostgreSQL is an object-relational database management system with an emphasis on extensibility and standards-compliance. As a database server, its primary function is to store data securely, supporting best practices, and to allow for retrieval at the request of other software applications. PostgreSQL implements the majority of the SQL2011 standard, is ACID-compliant and transactional using multiversion concurrency control (MVCC), and handles complex SQL queries using many indexing methods that are not available in other databases. It is cross-platform and runs on many operating systems including Linux, FreeBSD, OS X, Solaris, and Microsoft Windows.

PostgreSQL

Perl is a high-level, general-purpose, interpreted, dynamic programming languages with over 25 years of development. Perl 5 runs on over 100 platforms from portables to mainframes and is suitable for both rapid prototyping and large-scale development projects.  Perl gained widespread popularity as a Common Gateway Interface (CGI) scripting language, in part due to its regular expression and string parsing abilities. In addition to CGI, Perl is used for graphics programming, system administration, network programming, finance, bioinformatics, and other applications.