MySQL Forums
Forum List  »  Newbie

Re: simple query. why series column is giving problem
Posted by: Peter Brawley
Date: July 21, 2020 02:35PM

Quote

select * from equities where symbol like 'Tatasteel'

returns 178 rows

but some rows series is not EQ I wanted only EQ

...symbol like 'Tatasteel'... will return true only when `symbol` = 'Tatasteel'. Is that what is desired here? Likewise for `series1 like 'EQ'.

The Like operator exists mainly for approximate comparisons using wildcards. Read about equality and Like operators in the MySQL manual. If that doesn't clarify your issue, post a few relevant sample rows and amore precise description of the query requirement.

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.