Received: from maia.hub.org (maia-5.hub.org [200.46.204.29])
	by mail.postgresql.org (Postfix) with ESMTP id 71E42B5DBC4
	for <pgsql-sql-postgresql.org@mail.postgresql.org>;
	Sun, 10 Jul 2011 18:05:25 -0300 (ADT)
Received: from mail.postgresql.org ([200.46.204.86])
	by maia.hub.org (mx1.hub.org [200.46.204.29]) (amavisd-maia, port 10024)
	with ESMTP id 38755-02 for
	<pgsql-sql-postgresql.org@mail.postgresql.org>;
	Sun, 10 Jul 2011 21:05:19 +0000 (UTC)
X-Greylist: delayed 00:30:22.328269 by SQLgrey-1.7.6
Received: from bosmailout04.eigbox.net (bosmailout04.eigbox.net [66.96.189.4])
	by mail.postgresql.org (Postfix) with ESMTP id 66EAAB5DBD2
	for <pgsql-sql@postgresql.org>; Sun, 10 Jul 2011 18:05:19 -0300 (ADT)
Received: from bosmailscan07.eigbox.net ([10.20.15.7])
	by bosmailout04.eigbox.net with esmtp (Exim) id 1Qg0iO-0007gG-Be
	for pgsql-sql@postgresql.org; Sun, 10 Jul 2011 16:34:56 -0400
Received: from bosimpout01.eigbox.net ([10.20.55.1])
	by bosmailscan07.eigbox.net with esmtp (Exim) id 1Qg0iN-00039O-Jr
	for pgsql-sql@postgresql.org; Sun, 10 Jul 2011 16:34:55 -0400
Received: from bosauthsmtp06.eigbox.net ([10.20.18.6])
	by bosimpout01.eigbox.net with NO UCE
	id 6Law1h00107rX7u01LawXK; Sun, 10 Jul 2011 16:34:56 -0400
X-EN-OrigOutIP: 10.20.18.6
X-EN-IMPSID: 6Law1h00107rX7u01LawXK
Received: from [41.239.5.50] (helo=localhost.localdomain)
	by bosauthsmtp06.eigbox.net with esmtpsa (TLSv1:AES256-SHA:256)
	(Exim) id 1Qg0iN-0001SK-MK
	for pgsql-sql@postgresql.org; Sun, 10 Jul 2011 16:34:55 -0400
Message-ID: <4E19FEEB.8010900@softpro.bz>
Date: Sun, 10 Jul 2011 22:35:07 +0300
From: hatem gamal elzanaty <hatem@softpro.bz>
User-Agent: Thunderbird 2.0.0.24 (X11/20101213)
MIME-Version: 1.0
To: pgsql-sql@postgresql.org
Subject: what is similar to like operator in mysql for postgresql
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
X-EN-UserInfo: 
 9f6d45284487177df345665b293cfcf1:bf72d2e9cad2176c82d6320258861423
X-EN-AuthUser: hatem@softpro.bz
X-EN-OrigIP: 41.239.5.50
X-EN-OrigHost: unknown
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=-1.91 tagged_above=-5 required=5 tests=BAYES_00=-1.9,
	T_RP_MATCHES_RCVD=-0.01
X-Spam-Level: 
X-Archive-Number: 201107/36
X-Sequence-Number: 35606

hi all,
can you tell me what is similar to like operator in mysql for postgresql
hatem gamal