SELECT * FROM student
WHERE CONCAT(name
,class_id
,description
) LIKE ‘%关键字%’
模糊查询student表中name,class_id,description中包关键字的数据
参考:https://blog.csdn.net/yaoyao9565/article/details/51305854
SELECT * FROM student
WHERE CONCAT(name
,class_id
,description
) LIKE ‘%关键字%’
模糊查询student表中name,class_id,description中包关键字的数据
参考:https://blog.csdn.net/yaoyao9565/article/details/51305854