mysql(3) -FIND_IN_SET()
FIND_IN_SET(val,FieldName):fieldName 中包含 val 的参数
例如:
MENU_CODE | MENU_NAME |
01 | ttt |
0101 | sss |
0102 | mmm |
0203 | nnn |
SELECT * FROM t_core_menu WHERE FIND_IN_SET("01",MENU_CODE)
结果:MENU_CODE:01,MENU_NAME:ttt;
FIND_IN_SET(val,FieldName):fieldName 中包含 val 的参数
例如:
MENU_CODE | MENU_NAME |
01 | ttt |
0101 | sss |
0102 | mmm |
0203 | nnn |
SELECT * FROM t_core_menu WHERE FIND_IN_SET("01",MENU_CODE)
结果:MENU_CODE:01,MENU_NAME:ttt;