New topic: QSQL Parse/concatenate functions?
<http://forums.realsoftware.com/viewtopic.php?t=47258> Page 1 of 1 [ 1 post ] Previous topic | Next topic Author Message JohnV Post subject: QSQL Parse/concatenate functions?Posted: Mon Mar 11, 2013 12:15 pm Joined: Sun Jan 28, 2007 2:38 pm Posts: 193 I have a legacy mySQL Database with a Column in it called limit_liability The values look like this $1,000,000/$3,000,000 $200,000/$600,000 $1,000,000/$1,000,000 $500,000/$1,000,000 $500,000/$1,500,000 I need to use some sort of mySQL PARSE function to ORDER a sort by The First Number then the second number So that the results are $200,000/$600,000 $500,000/$1,000,000 $500,000/$1,500,000 $1,000,000/$1,000,000 $1,000,000/$3,000,000 Something like: SELECT DISTINCT limit_liability from myTable ORDER BY (HELP!) Top Display posts from previous: All posts1 day7 days2 weeks1 month3 months6 months1 year Sort by AuthorPost timeSubject AscendingDescending Page 1 of 1 [ 1 post ] -- Over 1500 classes with 29000 functions in one REALbasic plug-in collection. The Monkeybread Software Realbasic Plugin v9.3. http://www.monkeybreadsoftware.de/realbasic/plugins.shtml [email protected]
