From: | Luuk <luuk34(at)gmail(dot)com> |
---|---|
To: | pgsql-general(at)lists(dot)postgresql(dot)org |
Subject: | Re: Display table entries using partial column entry |
Date: | 2017-12-11 09:55:35 |
Message-ID: | ec730212-cfd1-a303-46a8-6f167f03dd66@invalid.lan |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On 11-12-17 00:39, Gmail wrote:
>
>
> On Dec 10, 2017, at 4:10 PM, Melvin Davidson <melvin6925(at)gmail(dot)com
> <mailto:melvin6925(at)gmail(dot)com>> wrote:
>
>>
>>
>> On Sun, Dec 10, 2017 at 4:50 PM, Sherman Willden
>> <operasopranos(at)gmail(dot)com <mailto:operasopranos(at)gmail(dot)com>> wrote:
>>
...
>> Thank you;
>>
>> Sherman
>>
>>
>> Sherman,
>> In the future, please be kind enough to provide PostgreSQL version and
>> O/S when posting to this listing.
>> Also include COLUMN HEADERS with all data and present the data
>> formatted so it is easily readable by humans.
>>
>> Presuming the # is your column divider, and the data you have provided
>> looks like this:
>> id #aria #artist
>> #a_artist #album_title
>> cbiylm06 #Caro mio ben #Cecilia
>> Bartoli # #Se tu m'ami
>> cbiylm07 #Pur dicesti, o bocca bella #Cecilia Bartoli
>> # #Se tu m'ami
>> cbiylm08 #Intorno all'idol mio #Cecilia
>> Bartoli # #Se tu m'ami
>> cbiylm09 #Nel cor più non mi sento #Cecilia Bartoli
>> # #Se tu m'ami
>> cbiylm10 #Il mio ben quando ve #Cecilia Bartoli
>> # #Se tu m'ami
>> cbiylm11 #O Leggiadri Occhi Belli #Cecilia Bartoli
>> # #Se tu m'ami
>> cbiylm12 #Il mio bel foco #Cecilia
>> Bartoli # #Se tu m'ami
>>
>> Then all you really need is:
>> SELECT *
>> FROM aria_precis
>> WHERE aria LIKE '%mio ben%';
>>
>> Pattern Matching
>> https://www.postgresql.org/docs/9.6/static/functions-matching.html
>
> Where I hop you will find the tilde operator ('~', '~*'). Why more fun.
You should be aware of case insensitivity.
LIKE '%mio ben%', will only match lower case
and, PostgreSQL-specific:
ILIKE '%mio ben%', will match any case
~ 'mio ben', will only match lower case
~* 'mio ben', will match any case
From | Date | Subject | |
---|---|---|---|
Next Message | Patrik Martinsson | 2017-12-11 10:19:24 | Unsigned RPM's ? |
Previous Message | Laurenz Albe | 2017-12-11 08:52:21 | Re: Is it possible to sort strings in EBCDIC order in PostgreSQL server? |