sql语句concat搜索不出结果

Question

为什么这条sql语句搜索不出结果呢？

SELECT * FROM person WHERE CONCAT(ID,'PASSWD','AUTHORITY','NAME','SEX','BIRTHDAY','DEPARTMENT','JOB','EDU_LEVEL','SPECIALTY',
'ADDRESS','TEL','EMAIL','STATE','REMARK') LIKE '%办公室%'

结果如下图：

Answer 1

SELECT * FROM person WHERE CONCAT(ID,PASSWD,AUTHORITY,NAME,SEX,BIRTHDAY,DEPARTMENT,JOB,EDU_LEVEL,SPECIALTY,
ADDRESS,TEL,EMAIL,STATE,REMARK) LIKE '%办公室%'

ID,PASSWD,AUTHORITY,NAME,SEX,BIRTHDAY,DEPARTMENT,JOB,EDU_LEVEL,SPECIALTY,
ADDRESS,TEL,EMAIL,STATE,REMARK这些字段要有值