mysql文法like concat文法使用記錄

例如表資料如下：

表名：base_org

baes_org_code | base_org_path_id

898000000030081 | 0,898000000000001,898000000030081

898000000030168 | 0,898000000000001,898000000030168

898000000030170 | 0,898000000000001,898000000030030,898000000030170

898000000030172 | 0,898000000000001,898000000030030,898000000030172

898000000030174 | 0,898000000000001,898000000030030,898000000030174

898000000030176 | 0,898000000000001,898000000030030,898000000030176

如果要根據某一個base_org_code的base_org_path_id列出所有跟path_id相關的資料

比如’898000000030170’ 這條資料，的path_id為’0,898000000000001,898000000030030,898000000030170’ 拆分目前path_id擷取所有的base_org_code資料行可用如下文法：

select * from base_org t where

– 目前子查詢字段隻能查詢一個

(select base_org_path_id

from base_org where base_org_code=‘898000000030170’ )

like concat(’%’,t.base_org_code,’%’)