首页0 <> find_in_set( `mat`.`MATERIALID`, `a`.`MIX_MAT_ID` ))) AS `MIX_MAT_NAME`

0 <> find_in_set( `mat`.`MATERIALID`, `a`.`MIX_MAT_ID` ))) AS `MIX_MAT_NAME`

时间: 2023-10-23 16:11:10 浏览: 54

PostgreSQL find_in_set 内核开发

5星 · 资源好评率100%

博客：PostgreSQL的学习心得和知识总结（六十五）|关于PostgreSQL数据库实现MySQL数据库find_in_set()函数的实现方案

This SQL code is selecting data from two tables `mat` and `a`. It is using the `find_in_set()` function to search for the `MATERIALID` in the `MIX_MAT_ID` column of table `a`. The result of this search is then used to display the corresponding `MIX_MAT_NAME` from table `a`. The `<>` operator is used to indicate not equal to.

阅读全文