Mysql按照汉语拼音首字母A-Z排序
select * from configuration ORDER BY CONVERT(configuration.name USING GBK) asc;
属性测试在最下边了,有些不对,修改为
select name from configuration ORDER BY CONVERT(configuration.name USING GB2312) asc;
嵌入使用SQL语句
通过text()使用SQL语句
all_configuration_list = all_configuration_list_query.order_by(text("CONVERT(configuration.name USING GB2312)")).all()
from sqlalchemy import text
query_result=session.query(Course).filter(text(“course_name=‘mysql’”)).all()
query_result=session.query(Course).filter(text(“course_name=:c_name and teacher_name=t_name”)).params(c_name=‘mysql’,t_name=‘Teacher Li’).all()
query_result=session.query(Course).filter(text(“select * from course where course_name=‘mysql’”)).all()