Hi!
I have a little problem getting the results I want from a MySQL table. I want to sort only on the alphanumeric characters in a varchar field. So that sorting on '#whatever-something#' actually sorts on 'whateversomething'.
I know it is quite easy to do this within PHP, but it would be even better to let MySQL take care of it.
Anybody out there knows how to do this?
All help greatly appreciated.
byebye
Bart
I have a little problem getting the results I want from a MySQL table. I want to sort only on the alphanumeric characters in a varchar field. So that sorting on '#whatever-something#' actually sorts on 'whateversomething'.
I know it is quite easy to do this within PHP, but it would be even better to let MySQL take care of it.
Anybody out there knows how to do this?
All help greatly appreciated.
byebye
Bart