如何用sql语句模糊查询姓名中有三个词的人名，比如“king george V”,where name like'...'
Ships(name,class,launched)
Find the names of all ships whose name consists of three or more words(e.g.,King George V).
呵呵，各位和我一样想复杂了，直接 name like '% % %'之间用空格就可以了，我用mysql测试的
谢谢大家了
最新回答
苍山有井名为空
2024-08-17 03:25:44
select * from
(
select 'A'=
case
when charindex(' ',A,1)>0 then replace(A,' ',' ')
when charindex(' ',A,1)>0 then replace(A,' ',' ')
when charindex(' ',A,1)>0 then replace(A,' ',' ')
when charindex(' ',A,1)>0 then replace(A,' ',' ')
when charindex(' ',A,1)>0 then replace(A,' ',' ')
when charindex(' ',A,1)>0 then replace(A,' ',' ')
when charindex(' ',A,1)>0 then replace(A,' ',' ')
when charindex(' ',A,1)>0 then replace(A,' ',' ')
when charindex(' ',A,1)>0 then replace(A,' ',' ')
when charindex(' ',A,1)>0 then replace(A,' ',' ')
end
from T
) M
where len(A)-len(replace(A,' ',''))>=2
希望以上对你有所帮助！
紫色的梦幻
2024-08-17 03:18:32
where length(name) - length(replace('name,' ','')) = 2
怜自惜
2024-08-17 01:49:43
三天三夜，三斤作业
2024-08-17 02:45:52
栖止你掌
2024-08-17 03:19:47
热门标签
