odbtools/odbctest/mql/uino/083.matchor.mql

select * from /system/field where name ='level3_name'
/**
output()
**/
;

select * from /dsq_stock2/stock_industry WHERE level1_name like '*食品饮料*' OR level2_name like '*食品饮料*' OR level3_name like '*食品饮料*'
/**
output()
**/
;

MATCH (stock:/dsq_stock2/a_stock)-[:a_stock_to_stock_industry*1..1]->(industry:/dsq_stock2/stock_industry WHERE level1_name like '*食品饮料*' OR level2_name like '*食品饮料*' OR level3_name like '*食品饮料*')
/**
output()
**/
;

MATCH (stock:/dsq_stock2/a_stock)-[:a_stock_to_stock_industry*1..1]->(industry:/dsq_stock2/stock_industry WHERE level1_name like '*食品饮料*' OR level2_name like '*食品饮料*' OR level3_name like '*食品饮料*')
return stock.id, stock.name, industry.level1_name, industry.level2_name, industry.level3_name
/**
output()
**/
;



select * from /dsq_stock2/stock_industry WHERE level1_name like '*食品饮料*' OR level2_name like '*食品饮料*' OR level3_name like '*食品饮料*'
/**
output()
**/
;