shan_cool Posted June 7, 2006 Share Posted June 7, 2006 Hi all, I have a mysql field with following data: TS_SAM_UA_1 TS_SAM_UA_5 TS_SAM_UA_2 TS_SAM_UA_11 TS_SAM_UA_10 TS_SAM_UA_14 I am Populationg all these values in a combo box...my query isSelect (Emp_Id + 0) as int_id From HR_Emp_Det order by int_idit displays as TS_SAM_UA_1 TS_SAM_UA_10 TS_SAM_UA_11 TS_SAM_UA_14 TS_SAM_UA_2 TS_SAM_UA_5but i need it as TS_SAM_UA_1 TS_SAM_UA_2 TS_SAM_UA_5 TS_SAM_UA_10 TS_SAM_UA_11 TS_SAM_UA_14 Rgds,shan Link to comment https://forums.phpfreaks.com/topic/11385-order-by-pbm/ Share on other sites More sharing options...
fenway Posted June 9, 2006 Share Posted June 9, 2006 The problem is that you can't cast these as numbers, since they're strings. You'd have to parse out the last part (from the last _ to the end) and then +0 just that component. If you know that each value has a similar format, you can probably rely on this, but it's not very robust. A combination of RIGHT() and LOCATE() shoudl work. Link to comment https://forums.phpfreaks.com/topic/11385-order-by-pbm/#findComment-43542 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.