zl程序教程

您现在的位置是:首页 >  数据库

当前栏目

Mysql字符串常量行转列

2023-03-07 09:15:48 时间
SELECT
	SUBSTRING_INDEX( SUBSTRING_INDEX( '7654,7698,7782,7788', ',', help_topic_id + 1 ), ',',- 1 )
	 AS num 
FROM
	mysql.help_topic 
WHERE
	help_topic_id < LENGTH( '7654,7698,7782,7788' )- LENGTH(
	REPLACE ( '7654,7698,7782,7788', ',', '' ))+ 1