解释:此处查询id不在pid出现,以/qwe开头,userId为15的数据。子查询加上where是为了加快查询效率。
SELECT * from file where filePath like concat( "/qwe", '%') and userId =15 and id NOT IN(SELECT pid from file where filePath like concat( "/qwe", '%') and userId =15)
2024-01-19 16:13:04
解释:此处查询id不在pid出现,以/qwe开头,userId为15的数据。子查询加上where是为了加快查询效率。
SELECT * from file where filePath like concat( "/qwe", '%') and userId =15 and id NOT IN(SELECT pid from file where filePath like concat( "/qwe", '%') and userId =15)