表:
sql语句
select *, max(company_id) from b2f_order_ordrtype_constructtype tmp where company_id in (0, 1) and order_type = 'mea-inst' and take_type = 2
and '090' in (order_status)
发现不行的,用数字去匹配结果只能匹配第一个数字,因为会把整个字符串当作字符串转成数字 ,号后面的自动忽略。用字符串去匹配,必须完整匹配