大虾!!帮帮忙!!查询问题!!

如果要查询的字符串中有引号怎么办???
例如:
SELECT * FROM tx WHERE Name='aa'aa'

---------------------------------------------------------------

SELECT * FROM tx WHERE Name='aa''aa'
---------------------------------------------------------------

SELECT * FROM tx WHERE Name='aa''aa'
---------------------------------------------------------------

select ''''
select ''''''
select char(39)
---------------------------------------------------------------

SELECT * FROM tx WHERE Name='aa''aa'

'' 表示'
---------------------------------------------------------------

SELECT * FROM tx WHERE Name='aa''aa'

Published At
Categories with 数据库类
Tagged with
comments powered by Disqus