组合查询的优化,谢谢
sql = "select * from book where bname like '%" & txtbname.Text & "%' and bauthor like '%" & txtauthor.Text & "%' and bpublish like '%" & txtpublish.Text & "%' and bdescription like '%" & txtdescription.Text & "%' order by bookid desc"
组合查询,有是四个组合条件,这样写是不是效率比较低,我该怎么优化一下呢?
谢谢。