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

* from t where t like 'fo\_%' escape '\';   t -- fo_ fo_x (2 rows) Cheers, Paul On Tue, Mar 10, 2020 at 1:49 PM sivapostg...@yahoo.com wrote: > > Hello, > > What returns when I run a query like this; > > Select * from test where name like 'co_%'; >

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

ul On Tue, Mar 10, 2020 at 1:49 PM sivapostg...@yahoo.com wrote: > > 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 >

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

On Tue, Mar 10, 2020 at 12:49:01PM +, sivapostg...@yahoo.com wrote: > 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 >

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

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