Brian Mansell wrote:
This is totally possible...
Chris say your table is test, and the column is test_col.. use the
following, and if the number is always at the end.. and always has a
space in front of it this will work:
SELECT test_col, SUBSTRING_INDEX(test_col, '', 1) as test_col_str,
I'm wondering if there is a way to do a numeric sort when the number
exists in a string. More clearly, take for example:
Radius 1200
Radius 1500
Radius 1800
Radius 300
Radius 600
Radius 900
Being that character wise 1 is before 3, I'm wondering if there's a way
through the database to
This is totally possible...
Chris say your table is test, and the column is test_col.. use the
following, and if the number is always at the end.. and always has a
space in front of it this will work:
SELECT test_col, SUBSTRING_INDEX(test_col, '', 1) as test_col_str,
SUBSTRING_INDEX(test_col, '