X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 477265287E for ; Fri, 5 Aug 2005 07:25:14 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 70063-03 for ; Fri, 5 Aug 2005 10:25:09 +0000 (GMT) Received: from fep32.mail.dk (fep32.mail.dk [80.160.76.196]) by svr1.postgresql.org (Postfix) with ESMTP id ED4F15280D for ; Fri, 5 Aug 2005 07:25:07 -0300 (ADT) Received: from fep40.mail.dk ([195.41.46.140]) by fep32.mail.dk (InterMail vM.6.01.05.00 201-2131-123-20050610) with ESMTP id <20050805102506.BOHQ28348.fep32.mail.dk@fep40.mail.dk>; Fri, 5 Aug 2005 12:25:06 +0200 Received: from [192.168.1.157] (really [213.173.246.2]) by fep40.mail.dk (InterMail vG.1.02.00.02 201-2136-104-102-20041210) with ESMTP id <20050805102506.KIRB10792.fep40.mail.dk@[192.168.1.157]>; Fri, 5 Aug 2005 12:25:06 +0200 Message-ID: <42F33E53.3000002@perlpimp.dk> Date: Fri, 05 Aug 2005 12:24:19 +0200 From: Ian Johannesen Reply-To: ij@perlpimp.dk Organization: The nation of pimps! User-Agent: Debian Thunderbird 1.0.2 (X11/20050602) X-Accept-Language: en-us, en MIME-Version: 1.0 To: pgsql-sql@postgresql.org Cc: Rob Kirkbride Subject: Re: 'select where' using multiple columns. References: <42F33585.1090706@rkcomputing.co.uk> In-Reply-To: <42F33585.1090706@rkcomputing.co.uk> Content-Type: multipart/signed; protocol="application/x-pkcs7-signature"; micalg=sha1; boundary="------------ms010606090406090105080207" X-Authentication-Info: Submitted using SMTP AUTH at fep40.mail.dk from [213.173.246.2] at Fri, 5 Aug 2005 12:25:05 +0200 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests= X-Spam-Level: X-Archive-Number: 200508/22 X-Sequence-Number: 22250 This is a cryptographically signed message in MIME format. --------------ms010606090406090105080207 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Hi. Rob Kirkbride wrote: > I've googled around for this but can't see a decent way of doing this : > > I've got a persons name which is being stored say in 3 columns :- > Title, Forename_1, Forename_2, Surname. I want to allow a search say for > 'John Smith'. Problem is I can't just break it up into forename and > surname because I won't also know. > Is there a way to do something like a > 'select * where forename_1,forename_2,surname like '%String%' ?? > > Thanks for any help. Apologies if its a FAQ. SELECT * FROM table WHERE forename_1 || ' ' || forename_2 || ' ' || surname LIKE '%String%'; -- Digitally Yours, Ian Johannesen web: http://perlpimp.dk/ msn: ij@perlpimp.dk cel: +45 31 13 73 76 --------------ms010606090406090105080207 Content-Type: application/x-pkcs7-signature; name="smime.p7s" Content-Transfer-Encoding: base64 Content-Disposition: attachment; filename="smime.p7s" Content-Description: S/MIME Cryptographic Signature MIAGCSqGSIb3DQEHAqCAMIACAQExCzAJBgUrDgMCGgUAMIAGCSqGSIb3DQEHAQAAoIIKbjCC BTMwggQboAMCAQICBD/HTWgwDQYJKoZIhvcNAQEFBQAwMTELMAkGA1UEBhMCREsxDDAKBgNV BAoTA1REQzEUMBIGA1UEAxMLVERDIE9DRVMgQ0EwHhcNMDQxMTE2MjAzODMyWhcNMDYxMTE2 MjEwODMyWjB2MQswCQYDVQQGEwJESzEpMCcGA1UEChMgSW5nZW4gb3JnYW5pc2F0b3Jpc2sg dGlsa255dG5pbmcxPDAVBgNVBAMTDklhbiBKb2hhbm5lc2VuMCMGA1UEBRMcUElEOjkyMDgt MjAwMi0yLTI1MjAxOTIwOTYzMTCBnzANBgkqhkiG9w0BAQEFAAOBjQAwgYkCgYEA4ZnF+fqQ SHafuYwvV0bv4I7+XYEvjSb7ymuxrLCjHm/FS/flV5DjF8R/SnKSb2ye79HK/ONVrro74cgM AH5OvVm7Z7MWGoNPXT1B9nWPgEEUT08vu3cyqSOF9/xanEmH0A3s8DYqX+GChbszEKpgZoZo bzc0Thyk9Us6gYyA00cCAwEAAaOCApAwggKMMA4GA1UdDwEB/wQEAwID+DArBgNVHRAEJDAi gA8yMDA0MTExNjIwMzgzMlqBDzIwMDYxMTE2MjEwODMyWjCCATcGA1UdIASCAS4wggEqMIIB JgYKKoFQgSkBAQEBATCCARYwLwYIKwYBBQUHAgEWI2h0dHA6Ly93d3cuY2VydGlmaWthdC5k ay9yZXBvc2l0b3J5MIHiBggrBgEFBQcCAjCB1TAKFgNUREMwAwIBARqBxkZvciBhbnZlbmRl bHNlIGFmIGNlcnRpZmlrYXRldCBn5mxkZXIgT0NFUyB2aWxr5XIsIENQUyBvZyBPQ0VTIENQ LCBkZXIga2FuIGhlbnRlcyBmcmEgd3d3LmNlcnRpZmlrYXQuZGsvcmVwb3NpdG9yeS4gQmVt 5nJrLCBhdCBUREMgZWZ0ZXIgdmlsa+VyZW5lIGhhciBldCBiZWdy5m5zZXQgYW5zdmFyIGlm dC4gcHJvZmVzc2lvbmVsbGUgcGFydGVyLjAZBgNVHREEEjAQgQ5pakBwZXJscGltcC5kazCB kAYDVR0fBIGIMIGFMEqgSKBGpEQwQjELMAkGA1UEBhMCREsxDDAKBgNVBAoTA1REQzEUMBIG A1UEAxMLVERDIE9DRVMgQ0ExDzANBgNVBAMTBkNSTDQ1MjA3oDWgM4YxaHR0cDovL2NybC5v Y2VzLmNlcnRpZmlrYXQuZGsvb2Nlcy8xMDcwMDI2MDg4LmNybDAfBgNVHSMEGDAWgBRgtYXs VmR+EhknZx1QFUtzrjv5EjAdBgNVHQ4EFgQUsbnzIayDgYc+YIL2yEGRb3HAUwowCQYDVR0T BAIwADAZBgkqhkiG9n0HQQAEDDAKGwRWNy4wAwIDqDANBgkqhkiG9w0BAQUFAAOCAQEAL7wl b+ANvbsjIses+MAVzf0q4fcm/Gh7HbzpI+i9kzfM4pb1N95fUDYX6Pm3eYxN1WSou+N+mWaf 31nG7OP+/TV9npkYOAjZ5ImWMjdxN4Ez01lLM3NB63YOuAc26yf7pxVGJLNkNcXFNLaoVm18 aM6pj01TEcncDXO0PokTgl+bEpY2ouOT9ySh0IRvnO9aDVlhrEll4mgwd7JbtPBpzUq1KpdG t9hGxyPHIybMEp69aXbha4dx4ba3es89Xo1IwCWVuJfyaFDWD8PhUtvQE8uJQpe0uot7evDY XUDYU1StQGikXvf39X0ZpBg8vLgHojZG3FD7AQXpCzS8vZ7jrjCCBTMwggQboAMCAQICBD/H TWgwDQYJKoZIhvcNAQEFBQAwMTELMAkGA1UEBhMCREsxDDAKBgNVBAoTA1REQzEUMBIGA1UE AxMLVERDIE9DRVMgQ0EwHhcNMDQxMTE2MjAzODMyWhcNMDYxMTE2MjEwODMyWjB2MQswCQYD VQQGEwJESzEpMCcGA1UEChMgSW5nZW4gb3JnYW5pc2F0b3Jpc2sgdGlsa255dG5pbmcxPDAV BgNVBAMTDklhbiBKb2hhbm5lc2VuMCMGA1UEBRMcUElEOjkyMDgtMjAwMi0yLTI1MjAxOTIw OTYzMTCBnzANBgkqhkiG9w0BAQEFAAOBjQAwgYkCgYEA4ZnF+fqQSHafuYwvV0bv4I7+XYEv jSb7ymuxrLCjHm/FS/flV5DjF8R/SnKSb2ye79HK/ONVrro74cgMAH5OvVm7Z7MWGoNPXT1B 9nWPgEEUT08vu3cyqSOF9/xanEmH0A3s8DYqX+GChbszEKpgZoZobzc0Thyk9Us6gYyA00cC AwEAAaOCApAwggKMMA4GA1UdDwEB/wQEAwID+DArBgNVHRAEJDAigA8yMDA0MTExNjIwMzgz MlqBDzIwMDYxMTE2MjEwODMyWjCCATcGA1UdIASCAS4wggEqMIIBJgYKKoFQgSkBAQEBATCC ARYwLwYIKwYBBQUHAgEWI2h0dHA6Ly93d3cuY2VydGlmaWthdC5kay9yZXBvc2l0b3J5MIHi BggrBgEFBQcCAjCB1TAKFgNUREMwAwIBARqBxkZvciBhbnZlbmRlbHNlIGFmIGNlcnRpZmlr YXRldCBn5mxkZXIgT0NFUyB2aWxr5XIsIENQUyBvZyBPQ0VTIENQLCBkZXIga2FuIGhlbnRl cyBmcmEgd3d3LmNlcnRpZmlrYXQuZGsvcmVwb3NpdG9yeS4gQmVt5nJrLCBhdCBUREMgZWZ0 ZXIgdmlsa+VyZW5lIGhhciBldCBiZWdy5m5zZXQgYW5zdmFyIGlmdC4gcHJvZmVzc2lvbmVs bGUgcGFydGVyLjAZBgNVHREEEjAQgQ5pakBwZXJscGltcC5kazCBkAYDVR0fBIGIMIGFMEqg SKBGpEQwQjELMAkGA1UEBhMCREsxDDAKBgNVBAoTA1REQzEUMBIGA1UEAxMLVERDIE9DRVMg Q0ExDzANBgNVBAMTBkNSTDQ1MjA3oDWgM4YxaHR0cDovL2NybC5vY2VzLmNlcnRpZmlrYXQu ZGsvb2Nlcy8xMDcwMDI2MDg4LmNybDAfBgNVHSMEGDAWgBRgtYXsVmR+EhknZx1QFUtzrjv5 EjAdBgNVHQ4EFgQUsbnzIayDgYc+YIL2yEGRb3HAUwowCQYDVR0TBAIwADAZBgkqhkiG9n0H QQAEDDAKGwRWNy4wAwIDqDANBgkqhkiG9w0BAQUFAAOCAQEAL7wlb+ANvbsjIses+MAVzf0q 4fcm/Gh7HbzpI+i9kzfM4pb1N95fUDYX6Pm3eYxN1WSou+N+mWaf31nG7OP+/TV9npkYOAjZ 5ImWMjdxN4Ez01lLM3NB63YOuAc26yf7pxVGJLNkNcXFNLaoVm18aM6pj01TEcncDXO0PokT gl+bEpY2ouOT9ySh0IRvnO9aDVlhrEll4mgwd7JbtPBpzUq1KpdGt9hGxyPHIybMEp69aXbh a4dx4ba3es89Xo1IwCWVuJfyaFDWD8PhUtvQE8uJQpe0uot7evDYXUDYU1StQGikXvf39X0Z pBg8vLgHojZG3FD7AQXpCzS8vZ7jrjGCAiowggImAgEBMDkwMTELMAkGA1UEBhMCREsxDDAK BgNVBAoTA1REQzEUMBIGA1UEAxMLVERDIE9DRVMgQ0ECBD/HTWgwCQYFKw4DAhoFAKCCAUcw GAYJKoZIhvcNAQkDMQsGCSqGSIb3DQEHATAcBgkqhkiG9w0BCQUxDxcNMDUwODA1MTAyNDE5 WjAjBgkqhkiG9w0BCQQxFgQUXiJ8oP6WKlf+B18r69rA+5TicU8wSAYJKwYBBAGCNxAEMTsw OTAxMQswCQYDVQQGEwJESzEMMAoGA1UEChMDVERDMRQwEgYDVQQDEwtUREMgT0NFUyBDQQIE P8dNaDBKBgsqhkiG9w0BCRACCzE7oDkwMTELMAkGA1UEBhMCREsxDDAKBgNVBAoTA1REQzEU MBIGA1UEAxMLVERDIE9DRVMgQ0ECBD/HTWgwUgYJKoZIhvcNAQkPMUUwQzAKBggqhkiG9w0D BzAOBggqhkiG9w0DAgICAIAwDQYIKoZIhvcNAwICAUAwBwYFKw4DAgcwDQYIKoZIhvcNAwIC ASgwDQYJKoZIhvcNAQEBBQAEgYDBCgbbQEzEYrMRH0g7kcPJZPWkuRr0i3+NP9+pWcBiE8UV PTPOQYY+AwNOzm/Ao3XXmPwu9SoGpTVizBInCFwkiaOSQ5ykKf4UBUrsTxu/6HD2wv52g59k Ozo/TJhbg33FHThOetzoBqdqMVnVZfHZ/gAyfxGQdFUGIyg4MIrhmQAAAAAAAA== --------------ms010606090406090105080207--