MYSQL 字段权重排序

 这个东西基本思路就是按照需求造个临时表（union），新表里的权重是动态生成的。找了一圈这是最简单粗暴的方式

( SELECT
	(weight_v2 + 10000) AS tmp ,
	yun_hits,
	title,
	weight_v2 
	FROM
		fv_biaozhun 
	WHERE
		( title LIKE '%葡聚糖%' OR st_no LIKE '%葡聚糖%' ) 
		AND `status` = 3 
	ORDER BY
		weight_v2 DESC 
	) UNION ALL
	(
	SELECT
		weight_v2 AS tmp,yun_hits, title,
		weight_v2 
	FROM
		fv_biaozhun 
	WHERE
		( summary LIKE '%葡聚糖%' OR food_note LIKE '%葡聚糖%' OR cosmetics_note LIKE '%葡聚糖%' ) 
		AND `status` = 3 
	ORDER BY
		weight_v2 DESC 
	) 
	ORDER BY tmp DESC,yun_hits DESC