Question

sql 查询一个表内某一字段相似数据 (在线等)

举例：表A中有字段A1.如何查询表A中A1字段所有相似记录
部分相似即可
表A下 有1000条记录
我想查询1000条记录内A1字段相似的记录。

Answer 1

select A1 from A where A1 like '*相似的字符*'
推荐用“ * ” 此通配符可以代表很多字符并不像“%”只局限一个

Answer 2

private Integer skuid;
private Breed breed;
private Variety variety;
private String skuname;

Answer 3

create proc Myproc
as
begin
declare @t table(ichar varchar(2))
declare @char varchar(100)
declare @tb table(A1 varchar(100))
declare cur1 cursor for select itname from bd_itemdoc
open cur1
Fetch next from cur1 into @char
while @@fetch_status=0
begin
if (select count(*) from @t where charindex(ichar,@char)>0)>0
insert into @tb values(@char)
else
begin
declare @len int
set @len=len(@char)
while @len>0
begin
insert into @t values(left(@char,1))
set @len=@len-1
set @char=right(@char,@len)
end
end
Fetch next from cur1 into @char
end
close cur1
deallocate cur1
select * from bd_itemdoc where itname in(select A1 from @tb)
end

--执行方法:

--exec Myproc

Answer 4

不知道你说的相似是如何相似？可以试一下用Charindex

Answer 5

在查找菜单中输入A1字段中所出现的字符