have more then one value inside the select like in mysql

[sql]

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

[J013]

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%'

[sql]

in mysql you can use
and (FeeType like'Cont Fee %' Or FeeType ='Comp Fee Doposit')
________
Herbal Health Shop