mysql字段模糊匹配关联_mysql关联模糊查询他表字段

如下：订单表关联了用户的id(多个)，要根据用户名模糊查询订单信息，但是订单表只有id。创建视图用不着，咱也没权限。于是如下

SELECT * FROM (

SELECT cu.id AS 'id',cu.version AS 'version',cu.cid AS 'cid',cu.uid AS 'uid',cu.shopName AS 'shopName',cu.address AS 'address',

cu.totalPrice AS 'totalPrice',cu.orderType AS 'orderType',

cu.state AS 'state',cu.cCreateTime AS 'cCreateTime',cu.decorate AS 'decorate',cu.area AS 'area',cu.roomArea AS 'roomArea',

cu.machinePrice AS 'machinePrice',cu.caid AS 'caid',

cu.cooperationtypeid AS 'cooperationtypeid',cu.cooperationRebate AS 'cooperationRebate',cu.cooperationPrcie AS 'cooperationPrcie',

cu.machineDiscount AS 'machineDiscount',cu.alreadyPaid AS 'alreadyPaid',cu.updateTime AS 'updateTime',cu.cooperationdeposit AS 'c