LoginSignup
0
1

MySQL 保存された文字数が多い順

Last updated at Posted at 2017-09-28
SELECT
	CHAR_LENGTH({調べたいカラム名}) as str_num
FROM
	{対象のテーブル名}
ORDER BY
	str_num DESC
0
1
0

Register as a new user and use Qiita more conveniently

  1. You get articles that match your needs
  2. You can efficiently read back useful information
  3. You can use dark theme
What you can do with signing up
0
1