SQL 要询中,比较条件中有关键字怎么查询? 比如 select * from 表A where 字段A like '5kkk['declare @s1 as varchar(10) declare @s2 as varchar(10)set @s1 = '11[' set @s2 = '['if charindex(@s2,@s1) > 0 print '1' else print '2'---- 1
晕。一定我没说明白,我做一个查询,条件中有个[号。自己解决了。再加个通配符 写成 select * from 表A where 字段A like '5kkk[[]' 就是查 所有 like 5kkk[的数据了
SQL 要询中,比较条件中有关键字怎么查询?
skywolfY(莫愁) ( ) 信誉:100 2007-09-24 15:38:24 得分: 0
晕。一定我没说明白,我做一个查询,条件中有个[号。自己解决了。再加个通配符 写成 select * from 表A where 字段A like '5kkk[[]' 就是查 所有 like 5kkk[的数据了 ----------------------------select * from t where 字段A like '%5kkke[%'escape 'e'
create table # ( name varchar(10) ) insert into # select '212sdf[d' union all select 'kjk[]kd' union all select '34kd'select * from # where name like '%e[%' escape 'e'name ---------- 212sdf[d kjk[]kd(2 row(s) affected)
多谢 fa_ge(鶴嘯九天) ( ) 信誉:100 让我知道了另一种方法。不可好象有些不好处理create table # ( [name] varchar(10) ) insert into # select '[eeesdf[d' union all select 'kjk[]kd' union all select '34kd'select * from # where [name] like 'e[eee%' escape 'e' drop table #
skywolfY(莫愁) ( ) 信誉:100 2007-09-24 15:38:24 得分: 0 晕。一定我没说明白,我做一个查询,条件中有个[号。自己解决了。再加个通配符 写成 select * from 表A where 字段A like '5kkk[[]' 就是查 所有 like 5kkk[的数据了 ----------------------------select * from t where 字段A like '%5kkke[%'escape 'e' ------------------------------------------------------------你说的相当对了
比如 select * from 表A where 字段A like '5kkk['declare @s1 as varchar(10)
declare @s2 as varchar(10)set @s1 = '11['
set @s2 = '['if charindex(@s2,@s1) > 0
print '1'
else
print '2'----
1
select * from 表A where 字段A like '5kkk[[]'
就是查 所有 like 5kkk[的数据了
晕。一定我没说明白,我做一个查询,条件中有个[号。自己解决了。再加个通配符 写成
select * from 表A where 字段A like '5kkk[[]'
就是查 所有 like 5kkk[的数据了
----------------------------select * from t where 字段A like '%5kkke[%'escape 'e'
(
name varchar(10)
)
insert into #
select '212sdf[d' union all
select 'kjk[]kd' union all
select '34kd'select * from # where name like '%e[%' escape 'e'name
----------
212sdf[d
kjk[]kd(2 row(s) affected)
(
[name] varchar(10)
)
insert into #
select '[eeesdf[d' union all
select 'kjk[]kd' union all
select '34kd'select * from # where [name] like 'e[eee%' escape 'e'
drop table #
晕。一定我没说明白,我做一个查询,条件中有个[号。自己解决了。再加个通配符 写成
select * from 表A where 字段A like '5kkk[[]'
就是查 所有 like 5kkk[的数据了
----------------------------select * from t where 字段A like '%5kkke[%'escape 'e'
------------------------------------------------------------你说的相当对了