django支持原生mysql语句,但是语句中有 % 符号时,会报错TypeError: not enough arguments for format string
直接把 % 改成 %% 可解决。如下:
错误写法:
bookObj = books.objects.raw(''' select * from books where name like "%python%" ''')
正确写法:
bookObj = books.objects.raw(''' select * from books where name like "%%python%%" ''')