Re: simple query. why series column is giving problem
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.
Subject
Written By
Posted
Re: simple query. why series column is giving problem
July 21, 2020 02:35PM
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.