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

Filed under:

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

Related posts about mysql