Member Avatar for 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

  • 2 Contributors
  • 2 Replies
  • 115 Views
  • 1 Day Discussion Span
  • Latest Post Latest Post by xibnoe
Member Avatar for fleetwood

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

Member Avatar for xibnoe

the problem is the length of a,b,c,b always change (not same ) in every data. ex:
Kjs.231.6753.55
HHSp.23322.4423.11

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.