Re: select * from test where name like 'co_%'

From: "sivapostgres(at)yahoo(dot)com" <sivapostgres(at)yahoo(dot)com>
To: Postgresql General Group <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: select * from test where name like 'co_%'
Date: 2020-03-10 12:49:01
Message-ID: 1482349013.1084585.1583844541651@mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello,
What returns when I run a query like this;
Select * from test where name like 'co_%';
I expect anything that starts with 'co_' and NOT 'co' only.  Am I right?  But I get every names that starts with 'co'. Why ?
Happiness Always
BKR Sivaprakash

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Kenneth Marshall 2020-03-10 12:54:28 Re: select * from test where name like 'co_%'
Previous Message PegoraroF10 2020-03-10 12:16:11 Re: How to discover what table is