2011-03-30 文字数を取得 SQLite MySQL 備忘録 SQLite SELECT artist, LENGTH(artist) FROM music ORDER BY LENGTH(artist) DESC MySQLでも使えるが、文字数ではなくバイト数が返ってくる。 MySQL SELECT no, artist, CHAR_LENGTH(artist) FROM music ORDER BY CHAR_LENGTH(artist) DESC