select count(*) from USERTABLE where username LIKE CONCAT ('%',#{user.username},'%')

1.Select count(*) from与Select * from的区别

       Select count(*) from表示当前所查表的总条数

       Select * from 表示当前多查表的全部内容

2.username LIKE CONCAT ('%',#{user.username},'%')

concat拼接字符串

3.MySQL:
SELECT CONCAT(A,B) FROM Table WHERE B= 'b';

结果：

'ab'