SQL语句:
SELECT * FROM t_line WHERE fromcolumn=? AND tocolumn like ? OR tocolumn like ? OR tocolumn like ? OR tocolumn like ? OR tocolumn like ? OR tocolumn like ? OR tocolumn like ? OR tocolumn like ? OR tocolumn like ? OR tocolumn like ? AND linetype=? ORDER BY rank DESC limit ?,?解释:之所以有那么多Or like,是因为 tocolumn 字段内容形式为:1,2,3,4,5,6,7,8,9我需要查询 包含 2,5,7的数据,(当然 这里为简单用数字代替)
问题:SQL里有个排序 Order by rank DESC,加上这个排序,就会报:java.sql.SQLException: Sort aborted异常去掉就能正常通过,请问各位大大们,这是什么问题啊,,需要怎么解决啊??
SELECT * FROM t_line WHERE fromcolumn=? AND tocolumn like ? OR tocolumn like ? OR tocolumn like ? OR tocolumn like ? OR tocolumn like ? OR tocolumn like ? OR tocolumn like ? OR tocolumn like ? OR tocolumn like ? OR tocolumn like ? AND linetype=? ORDER BY rank DESC limit ?,?解释:之所以有那么多Or like,是因为 tocolumn 字段内容形式为:1,2,3,4,5,6,7,8,9我需要查询 包含 2,5,7的数据,(当然 这里为简单用数字代替)
问题:SQL里有个排序 Order by rank DESC,加上这个排序,就会报:java.sql.SQLException: Sort aborted异常去掉就能正常通过,请问各位大大们,这是什么问题啊,,需要怎么解决啊??
最后怎么多了 这个 语法错误?