MySQL Forums
Forum List  »  Newbie

simple query. why series column is giving problem
Posted by: sridhar Raman
Date: July 21, 2020 12:08PM

I have a table equities where column names are

symbol varchar(45)
series varchar(4)
date1 Date
close_price Decimal(13,5)

My query

select * from equities where symbol like 'Tatasteel'

returns 178 rows

but some rows series is not EQ I wanted only EQ

so I changed my query

select * from equities where symbol like 'Tatasteel' and series like 'EQ'

returns 0 rows

I tried select * from equities where series = 'EQ'
even this returns 0rows

what i am doing wrong

Options: ReplyQuote




Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.