•
•
•
•
What is DaniWeb IT Discussion Community?
You're currently browsing the MySQL section within the Web Development category of DaniWeb, a massive community of 402,909 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 3,088 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Please support our MySQL advertiser: Programming Forums
Views: 929 | Replies: 2
 |
•
•
Join Date: Jun 2006
Posts: 7
Reputation: 
Rep Power: 0
Solved Threads: 0
Newbie Poster
order by.... i have a fied (book_number), the value is "aaa.bbbb.cccc.ddd", How can i sort the result order only by "bbbb" and ignore a, c, and d.
thanks
thanks
•
•
Join Date: Mar 2006
Posts: 1
Reputation:
Rep Power: 0
Solved Threads: 0
Newbie Poster
•
•
•
•
Originally Posted by xibnoe 
i have a fied (book_number), the value is "aaa.bbbb.cccc.ddd", How can i sort the result order only by "bbbb" and ignore a, c, and d.
thanks
Try using the SUBSTRING() function in the ORDER BY
|
•
•
•
•
•
•
•
•
DaniWeb MySQL Marketplace
•
•
•
•
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
Linear Mode
Similar Threads
- [B]What changes need to be made to the above database definition in order to solve al (Visual Basic 4 / 5 / 6)
- Listing Integers in Numerical Order (C)
- Sorting Not In Order (C)
- names in ascending order problem (C++)
- Changing Startup Programs Order (Windows NT / 2000 / XP / 2003)
- DOS C++, pulling boot order and hard drive parameters, (C++)
Other Threads in the MySQL Forum
- Previous Thread: MySQL INSERT not working. Why?
- Next Thread: Mysql Version
