-
have more then one value inside the select like in mysql
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
Last edited by sql; 03-06-2011 at 02:15 AM.
-
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
Last edited by sql; 03-06-2011 at 02:15 AM.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|