테이블에 id라는 컬럼에 있는 데이터 입니다. 이걸 가지고 정렬을 해야 하는데 골치가 아프네요
FDS1, FDS2, FDS3, FDS4 이런식으로 문자+숫자 인 것들을 차례대로 정렬시켜야 하는데
그냥 order by 해버리면 다음과 같이 정렬이 되네요 ㅠ.ㅠ 좀 도와주세요 @@
FDS1
FDS10
FDS11
FDS12
FDS13
FDS14
FDS15
FDS16
FDS17
FDS18
FDS19
FDS2
FDS20
FDS21
FDS22
FDS23
FDS24
FDS25
FDS26
FDS27
FDS28
FDS29
FDS3
FDS30
FDS31
FDS32
FDS33
FDS34
FDS4
FDS5
FDS6
FDS7
FDS8
FDS9
FDSA1
FDSA10
FDSA100
FDSA101
FDSA102
FDSA103
FDSA104
FDSA105
FDSA106
FDSA107
FDSA108
FDSA109
FDSA11
FDSA110
FDSA111
FDSA112
FDSA113
FDSA114
FDSA115
FDSA116
FDSA117
FDSA118
FDSA119
FDSA12
FDSA120
FDSA121
FDSA122
FDSA123
FDSA124
FDSA125
FDSA126
FDSA127
FDSA128
FDSA129
FDSA13
FDSA130
FDSA131
FDSA132
FDSA133
FDSA134
FDSA135
FDSA136
FDSA137
FDSA138
FDSA139
FDSA14
FDSA140
FDSA141
FDSA142
FDSA143
FDSA144
FDSA145
FDSA146
FDSA147
FDSA148
FDSA149
FDSA15
FDSA150
FDSA151
FDSA152
FDSA153
FDSA154
FDSA155
FDSA156
FDSA157
FDSA158
FDSA159
FDSA16
FDSA160
FDSA161
FDSA162
FDSA163
FDSA164
FDSA165
FDSA166
FDSA167
FDSA168
FDSA169
FDSA17
FDSA170
FDSA171
FDSA172
FDSA173
FDSA174
FDSA175
FDSA176
FDSA177
FDSA178
FDSA179
FDSA18
FDSA180
FDSA181
FDSA182
FDSA183
FDSA184
FDSA185
FDSA186
FDSA187
FDSA188
FDSA189
FDSA19
FDSA190
FDSA191
FDSA192
FDSA193
FDSA194
FDSA195
FDSA196
FDSA197
FDSA198
FDSA199
FDSA2
FDSA20
FDSA200
FDSA201
FDSA202
FDSA203
FDSA204
FDSA205
FDSA206
FDSA207
FDSA208
FDSA209
FDSA21
FDSA210
FDSA211
FDSA212
FDSA213
FDSA214
FDSA215
FDSA216
FDSA217
FDSA218
FDSA219
FDSA22
FDSA220
FDSA221
FDSA222
FDSA223
FDSA224
FDSA225
FDSA226
FDSA227
FDSA228
FDSA229
FDSA23
FDSA230
FDSA231
FDSA232
FDSA233
FDSA234
FDSA235
FDSA236
FDSA237
FDSA238
FDSA239
FDSA24
FDSA240
FDSA241
FDSA242
FDSA243
FDSA244
FDSA245
FDSA246
FDSA247
FDSA248
FDSA249
FDSA25
FDSA250
FDSA251
FDSA252
FDSA253
FDSA254
FDSA255
FDSA256
FDSA257
FDSA258
FDSA259
FDSA26
FDSA260
FDSA261
FDSA262
FDSA263
FDSA264
FDSA265
FDSA266
FDSA267
FDSA268
FDSA269
FDSA27
FDSA270
FDSA271
FDSA272
FDSA273
FDSA274
FDSA275
FDSA276
FDSA277
FDSA278
FDSA279
FDSA28
FDSA280
FDSA281
FDSA282
FDSA283
FDSA284
FDSA29
FDSA3
FDSA30
FDSA31
FDSA32
FDSA34
FDSA35
FDSA36
FDSA37
FDSA38
FDSA39
FDSA4
FDSA40
FDSA41
FDSA42
FDSA43
FDSA44
FDSA45
FDSA46
FDSA47
FDSA48
FDSA49
FDSA5
FDSA50
FDSA51
FDSA52
FDSA53
FDSA54
FDSA55
FDSA56
FDSA57
FDSA58
FDSA59
FDSA6
FDSA60
FDSA61
FDSA62
FDSA63
FDSA64
FDSA65
FDSA66
FDSA67
FDSA68
FDSA69
FDSA7
FDSA70
FDSA71
FDSA72
FDSA73
FDSA74
FDSA75
FDSA76
FDSA77
FDSA78
FDSA79
FDSA8
FDSA80
FDSA81
FDSA82
FDSA83
FDSA84
FDSA85
FDSA86
FDSA87
FDSA88
FDSA89
FDSA9
FDSA90
FDSA91
FDSA92
FDSA93
FDSA94
FDSA95
FDSA96
FDSA97
FDSA98
FDSA99
FDT001
FDT002
FDT003
FDT004
FDT005
FDT006
FDT007
FDT008
FDT009
FDT010
FDT011
FDT012
FDT013
FDT014
FDT015
FDT016
FDT017
FDT018
FDT019
FDT020
FDT021
FDT022
FDT023
FDT024
FDT025
FDT026
FDT027
FDT028
FDT029
FDT030
FDT031
FDT032
FDT033
FDT034
FDT035
FDT036
FDT037
FDT038
FDT039
FDT040
FDT041
FDT042
FDT043
FDT044
FDT045
FDT046
FDT047
FDT048
FDT049
FDT050
FDT051
FDT052
FDT053
FDT054
FDT055
FDT056
FDT057
FDT058
FDT059
FDT060
FDT061
FDT062
FDT063
FDT064
FDT065
FDT066
FDT067
FDT068
FDT069
FDT070
FFAS1
FFAS2
KFDS1
KFDS2
KFDS3
PFDT001
PFDT002
PFDT003
PFDT004
PFDT005
FDSS2
FDSS3
FDSS4
FDSS5
FDSS6
FDSS7
fds1
fds2
fds3
fds4
fds5
|