Select * from table where FeeType like ('Comp Fee Doposit%','Cont Fee%') is not working ?
it looks like the select like can use Select * from table
where FeeType in('a','b','c')
________
Ferrari 248 f1 specifications
Printable View
Select * from table where FeeType like ('Comp Fee Doposit%','Cont Fee%') is not working ?
it looks like the select like can use Select * from table
where FeeType in('a','b','c')
________
Ferrari 248 f1 specifications
I am not sure about mySQL's implementation of SQL, but I know with MS SQL you cannot compare two fields with one like operator. You would have to use logical comparison operators to compare against more fields.
ex:
Select * from table where FeeType like 'Comp Fee Doposit%' or FeeType like 'Cont Fee%'
in mysql you can use
and (FeeType like'Cont Fee %' Or FeeType ='Comp Fee Doposit')
________
Herbal Health Shop