畅购-day02 java.sql.SQLSyntaxErrorException: Unknown column*

mapper sql 传参错误导致：

"SELECT NAME,image FROM tb_brand WHERE id  IN (SELECT brand_id  FROM tb_category_brand WHERE category_id IN (SELECT id FROM tb_category WHERE NAME=${name})) ORDER BY seq"

Cause: java.sql.SQLSyntaxErrorException: Unknown column

org.springframework.jdbc.BadSqlGrammarException: 
### Error querying database.  Cause: java.sql.SQLSyntaxErrorException: Unknown column '手机' in 'where clause'
### The error may exist in com/changgou/goods/dao/BrandMapper.java (best guess)
### The error may involve com.changgou.goods.dao.BrandMapper.findListByCategoryName-Inline
### The error occurred while setting parameters
### SQL: SELECT NAME,image FROM tb_brand WHERE id  IN (SELECT brand_id  FROM tb_category_brand WHERE category_id IN (SELECT id FROM tb_category WHERE NAME=手机)) ORDER BY seq
### Cause: java.sql.SQLSyntaxErrorException: Unknown column '手机' in 'where clause'
; bad SQL grammar []; nested exception is java.sql.SQLSyntaxErrorException: Unknown column '手机' in 'where clause'

原因此处写成了${name}应该是#{name}