SELECT nickname,INSTR(nickname,'陆晓斌') `index` FROM `tbl_member` HAVING `index` > 0
SELECT * FROM tbl_member WHERE FIND_IN_SET(nickname,'陆晓斌')
mysql INSTR、FIND_IN_SET 检测字段是否有存在相对应字段
最新推荐文章于 2024-07-13 10:38:18 发布
SELECT nickname,INSTR(nickname,'陆晓斌') `index` FROM `tbl_member` HAVING `index` > 0
SELECT * FROM tbl_member WHERE FIND_IN_SET(nickname,'陆晓斌')