MyBatis查Java优学网教程：高效查询与懒加载优化实战指南

SELECT * FROM courses WHERE 1=1

AND name LIKE CONCAT('%', #{name}, '%')

AND category_id = #{category}

AND price >= #{minPrice}

SELECT id, title, cover_image, price, student_count FROM courses WHERE status = 'PUBLISHED' ORDER BY weight DESC, id DESC LIMIT 50