mysql find_in_set 用法

最新推荐文章于 2024-09-27 20:43:28 发布

admin⁠

最新推荐文章于 2024-09-27 20:43:28 发布

阅读量366

点赞数 4

文章标签： mysql 数据库

本文链接：https://blog.csdn.net/qq_19598963/article/details/139739641

版权

SELECT
	`a`.`orders_id`
FROM
	`cd_wms_orders` `a`
INNER JOIN `cd_wms_orderitems` `b` ON `a`.`orders_id` = `b`.`orders_id`
WHERE
	(
		a.type = 3
		AND a. STATUS != 99
		AND a.company_id = 11
		AND (
			a.orders_no LIKE "%123%"
			OR a.pono LIKE "%123%"
			OR find_in_set(
				a.orders_id,
				"1914,1915,1916,1956,1964,2054,2055,2059,2060,2088,2095,2283,2284,1854,1858,1859,1860,1863,1867,1900,1904,1957,1960,1961,2063,2076,2077,2096,2221,2242,2249,238180,238181,238182,238211,238212,238390,238405,238407,238577,238578,238746,238747,238866,238867,239131,239534,239536,239546,239622,239635,239636,239637,239638,239647,239649,239653,239660,239867,239918,239919,239920,239933,238630"
			)
		)
	)
GROUP BY
	`a`.`orders_id`
ORDER BY
	`a`.`orders_id` DESC