Received: from magus.postgresql.org ([87.238.57.229]) by malur.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1TJrYL-00007Z-PS for pgsql-sql@postgresql.org; Thu, 04 Oct 2012 19:57:49 +0000 Received: from smtp104.prem.mail.ac4.yahoo.com ([76.13.13.43]) by magus.postgresql.org with smtp (Exim 4.72) (envelope-from ) id 1TJrYJ-0007wk-Ca for pgsql-sql@postgresql.org; Thu, 04 Oct 2012 19:57:49 +0000 Received: (qmail 85129 invoked from network); 4 Oct 2012 19:57:45 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=DKIM-Signature:X-Yahoo-Newman-Property:X-YMail-OSG:X-Yahoo-SMTP:Received:From:To:References:In-Reply-To:Subject:Date:Message-ID:MIME-Version:Content-Type:Content-Transfer-Encoding:X-Mailer:Thread-Index:Content-Language; b=Xys1sb0sDYo+LpB/9ynIrv5nFZB/NJFsmPmBNQneKYWYWzU6jPGOrhuISiPTOhAIgHfUH2twVpBcHMho6UJ0uv3YXLB4JOwhtDTCkCPd5ajmhiIVE/3HWNGiuhi3yCqN7tvACH8LEZXcckhXCJMZd6WqkjAd1AHyPmLy7cDcYWQ= ; DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s1024; t=1349380665; bh=xrN3wprTeLR2lPmSmf5OnSigqz6TQfNbgn+X2zrgs50=; h=X-Yahoo-Newman-Property:X-YMail-OSG:X-Yahoo-SMTP:Received:From:To:References:In-Reply-To:Subject:Date:Message-ID:MIME-Version:Content-Type:Content-Transfer-Encoding:X-Mailer:Thread-Index:Content-Language; b=vDHwdZrNYd3btMlQQzeCJpUM11CqjmujWsIWn51+HYHVf80nBZ4b0pxJwzD2l2aR8Dv+smzM/vbaKEqzEx5adPv2TuK6kkasKCZuI8XjjCRngeE/vf5RVQQDhDUHpFALlkVpb7V22Knm2yyWru82e5blMthuTFJcsfBpjjCx+Ok= X-Yahoo-Newman-Property: ymail-3 X-YMail-OSG: .XMGz04VM1kh1WoB_i1DYyxQFXTOavrLSKkh_63dSQOTfg0 kXlhXAlN5y8TuYWo8hNGi2QCeQmarVH6kIo36WXdbPS3bnR.mYu2.q7UJFuW dELhy.rUA7MZcP8uXjbsdEjRfja6tmwJiT4qqo9zW3vKCCR0WaLjT8fnUD6a 7hRvGWrYxyRuSMDo9fn1HN0312hp3ZHEZYahfSd_qTOP7sSsAG4LhC4XE1uq 3VEoZpLUrcmg5uWMWT2L4F7NPqN.iLodapMTXDmWM9pwEqKdYbM5uWeAO1F1 m3K1UnqqBDE.VZhN9MLO9hqwT5PTA0EdWtVpNGMQz1Cs4gXVjd0VrLIUJGqN k4qaOGl.N__iQCVnBYGam_ubx1dMDhC5mmsVwjbHKSndwW7COYfZN0l5cPIp 2P7Ik5yYhRAdpKGqLYvndUosybYpI4WUArIoNahvJvIsOSIVnkzKf7N10UMi _d2fh X-Yahoo-SMTP: mpGJl6eswBD2IBufoVEg0Pa8gg-- Received: from WolfDog (polobo@24.93.23.188 with login) by smtp104.prem.mail.ac4.yahoo.com with SMTP; 04 Oct 2012 12:57:45 -0700 PDT From: "David Johnston" To: "'Fabio Ebner - Dna Solution'" , References: <506DE640.3050702@dnasolution.com.br> In-Reply-To: <506DE640.3050702@dnasolution.com.br> Subject: Re: String Search Date: Thu, 4 Oct 2012 15:57:28 -0400 Message-ID: <022001cda26a$7c13d500$743b7f00$@yahoo.com> MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit X-Mailer: Microsoft Outlook 14.0 Thread-Index: AQIf2ut8T/ct0oIseo0WVXN4aObi3JcFHe4g Content-Language: en-us X-Pg-Spam-Score: -4.1 (----) X-Archive-Number: 201210/21 X-Sequence-Number: 36892 > -----Original Message----- > From: pgsql-sql-owner@postgresql.org [mailto:pgsql-sql- > owner@postgresql.org] On Behalf Of Fabio Ebner - Dna Solution > Sent: Thursday, October 04, 2012 3:41 PM > To: pgsql-sql@postgresql.org > Subject: [SQL] String Search > > Anyone know the best way to do one select in String field? > > tks You are going to need to phrase a better question. In the meantime please read the documentation on the various built-in string functions available. I've provided links to the function index page (look for "string functions") as well as PostgreSQL's full text search capability since both are "string" related. http://www.postgresql.org/docs/9.2/interactive/functions.html http://www.postgresql.org/docs/9.2/interactive/textsearch.html My best guess is you want to learn about substring functions and/or regular expressions. David J.