回答編集履歴

1

フルーツ

2019/01/10 03:30

投稿

papinianus
papinianus

スコア12705

test CHANGED
@@ -1,5 +1,5 @@
1
1
  ```SQL
2
2
 
3
- select * from `tablename` where cout like '%りんご%' order by (LENGTH(cout) - LENGTH( REPLACE ( cout, "りんご", "") ) ) / LENGTH("りんご") DESC;
3
+ select * from フルーツ where cout like '%りんご%' order by (LENGTH(cout) - LENGTH( REPLACE ( cout, "りんご", "") ) ) / LENGTH("りんご") DESC;
4
4
 
5
5
  ```