在sql的模糊查询过程中,会遇到数据库类型是int的情况,此时无法使用模糊查询,而使用text强制转换可以简单的解决这个问题。
SELECT DISTINCT people.name, people.id
FROM people, students, course_enrolments, subjects, courses, staff, course_staff
WHERE course_enrolments.student = students.id
AND staff.id = course_staff.staff
AND course_staff.course = courses.id
AND courses.subject = subjects.id
AND course_enrolments.course = courses.id
AND staff.id = people.id
AND students.stype = 'intl'
AND subjects.career = 'PG'
AND course_enrolments.mark = 100
AND people.id::text LIKE '31%' //如果不用text转换类型,这里的模糊查询就会报错
;
本人也是查了很久sql类型转换的方法。。到头来还是这个比较简单快捷。
第一次发帖子,还是个技术小白,如果有问题还望各位dalao指正