Postgres Pro
Downloads
Home   >   mailing lists

Re: select * from test where name like 'co_%' - Mailing list pgsql-general

From sivapostgres@yahoo.com
Subject Re: select * from test where name like 'co_%'
Date
Msg-id 1482349013.1084585.1583844541651@mail.yahoo.com
Whole thread Raw
Responses Re: select * from test where name like 'co_%'  (Kenneth Marshall <ktm@rice.edu>)
Re: select * from test where name like 'co_%'  (Paul Foerster <paul.foerster@gmail.com>)
List pgsql-general
Tree view
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

pgsql-general by date:

Previous
From: PegoraroF10
Date:
Subject: Re: How to discover what table is
Next
From: Kenneth Marshall
Date:
Subject: Re: select * from test where name like 'co_%'