SQL模糊查询问题

[芒果树下初相遇]

SQL.Format(_T("select * from user where name like '%s'"),m_name);

这条语句模糊查询搞不出来啊，只能完全相同才出来

[ddszhan]

SQL.Format(_T("select * from user where name like \'%%%s%%\'"),m_name);

[zgl7903]

http://www.w3school.com.cn/sql/sql_wildcards.asphttp://www.w3school.com.cn/sql/sql_wildcards.asp

[芒果树下初相遇]

引用 1 楼 ddszhan 的回复:

SQL.Format(_T("select * from user where name like \'%%%s%%\'"),m_name);

你这个也不行啊，啥都查不出来

[芒果树下初相遇]

2楼正解，我自己后面写错了

[oyljerry]

SQL.Format(_T("select * from user where name like '%%s'"),m_name);