mysql query fails.It gives me invalid result
Posted
by
user2941349
on Stack Overflow
See other posts from Stack Overflow
or by user2941349
Published on 2013-11-02T09:48:16Z
Indexed on
2013/11/02
9:53 UTC
Read the original article
Hit count: 135
mysql
I have to write mysql query for fetching result from my database with a specified date and code like ABH18 or ABH17 or ABH19.I write the querly like below.
select * from tbl_transaction where trans_name like 'ABH19%' or trans_name like 'ABH18%' or trans_name like 'ABH17%' or trans_name like 'ABH15%' and date_of_vazhipad='2013-11-20' and trans_status='Completed successfully.'
There are no result in the DB satisfying all above conditions.But i got result with different dates.But i want to ensure the date_of_vazhipad='2013-11-20' so that the query may work properly
Thanks in advance
© Stack Overflow or respective owner