1、对tb_version_info表int类型字段version_code做模糊查询
SELECT * FROM `tb_version_info` where convert(version_code,CHAR(10)) LIKE '%1%';
2、对tb_version_info表vachar类型字段version_name做倒序查询,会自动比较ASCI值
SELECT * FROM `tb_version_info` order by version_name desc;
1、对tb_version_info表int类型字段version_code做模糊查询
SELECT * FROM `tb_version_info` where convert(version_code,CHAR(10)) LIKE '%1%';
2、对tb_version_info表vachar类型字段version_name做倒序查询,会自动比较ASCI值
SELECT * FROM `tb_version_info` order by version_name desc;