--try: select * from Tab_TouristTrack where newProduct+competitiveProducts+luxury+specialPreference+hotRecommend+characteristic+overflow+season+onVacation like '%1%'
select * from Tab_TouristTrack where newProduct='1' or competitiveProducts='1' or luxury='1' or specialPreference='1' or hotRecommend='1' or characteristic='1' or overflow='1' or season='1' or onVacation='1'虽然可以看起来简洁一点儿。select * from Tab_TouristTrack where newProduct + competitiveProducts + luxury + specialPreference + hotRecommend + characteristic + overflow + season + onVacation>0但这种写法效率上并不如上一种。
--try:
select * from Tab_TouristTrack where
newProduct+competitiveProducts+luxury+specialPreference+hotRecommend+characteristic+overflow+season+onVacation like '%1%'
where newProduct='1'
or competitiveProducts='1'
or luxury='1'
or specialPreference='1'
or hotRecommend='1'
or characteristic='1'
or overflow='1'
or season='1'
or onVacation='1'虽然可以看起来简洁一点儿。select * from Tab_TouristTrack
where newProduct + competitiveProducts + luxury + specialPreference + hotRecommend + characteristic + overflow + season + onVacation>0但这种写法效率上并不如上一种。