mysql - Why the query is giving result while the destCurrency is not 0 - -
select * xyz applyat = 'anita' , applyat = 'create' , country = '50' , dest_country = '108' , origincurrency = 'eur' , destcurrency = 0 , isenable = 'y' , agentid = 0 , module = 'abc' order ruleid desc
you should add quotes varchar
select * xyz applyat = 'anita' , applyat = 'create' , country = '50' , dest_country = '108' , origincurrency = 'eur' , destcurrency = '0' , isenable = 'y' , agentid = 0 , module = 'abc' order ruleid desc
Comments
Post a Comment