blocks|key|734292|text|您可能可以使用FreeText搜索MSSQL，但是可以使用它来处理名称。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|734293|http://msdn.microsoft.com/en-us/library/ms176078.aspx|offset|length|734294|entityMap|0|LINK|mutability|MUTABLE|url^0|0|0|1H|0|0^^$0|@$1|2|3|4|5|6|7|M|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|N|8|@]|9|@$D|O|E|P|1|Q]]|A|$]]|$1|F|3|-4|5|6|7|R|8|@]|9|@]|A|$]]]|G|$H|$5|I|J|K|A|$L|C]]]]

You might be able to use FreeText Search for MSSQL, but idk how that would handle the names.

<a href="http://msdn.microsoft.com/en-us/library/ms176078.aspx" rel="nofollow">http://msdn.microsoft.com/en-us/library/ms176078.aspx</a>

blocks|key|359204|text|如果您只是试图避免始终使用to+()语法，则可以声明变量(取决于DBMS)。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|359205|declare+@description+varchar(max)
set+@description=+UPPER('description');

select+
++++*+
from+
++++dm_user+
where+
++++@description+like+'%25FIRSTUSER_FIRSTNAME%25'+
++++OR+@description+like+'%25SECONDUSER_FIRSTNAME%25'+|code-block|syntax|javascript|359206|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

If your just trying to avoid using the the UPPER() syntax all the time you can declare the variable (depending on your DBMS)

<pre><code>declare @description varchar(max)
set @description= UPPER('description');

select 
 * 
from 
 dm_user 
where 
 @description like '%FIRSTUSER_FIRSTNAME%' 
 OR @description like '%SECONDUSER_FIRSTNAME%' 
</code></pre>

blocks|key|358459|text|如果您想避免多次编写LIKE，并且您正在使用MSSQL，请查看临时表或表变量。|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|358460|一般的想法是将所有搜索词(名字-姓氏组合)放入一个临时表/表变量中，然后执行一个查询，检查dm_user.description是否包含至少一个搜索项。|358461|SELECT+DISTINCT+u.id
FROM+dm_users+AS+u,+#tmp+as+t
WHERE+dm_users.description+LIKE+N'%25'+%2B+t.searchterm+%2B+'%25'|code-block|syntax|javascript|358462|entityMap|0|LINK|mutability|MUTABLE|url|http://msdn.microsoft.com/en-us/library/ms174979.aspx|1|http://msdn.microsoft.com/en-us/library/ms188927.aspx^0|A|4|V|3|0|Z|3|1|0|19|J|0|0^^$0|@$1|2|3|4|5|6|7|W|8|@$9|X|A|Y|B|C]]|D|@$9|Z|A|10|1|11]|$9|12|A|13|1|14]]|E|$]]|$1|F|3|G|5|6|7|15|8|@$9|16|A|17|B|C]]|D|@]|E|$]]|$1|H|3|I|5|J|7|18|8|@]|D|@]|E|$K|L]]|$1|M|3|-4|5|6|7|19|8|@]|D|@]|E|$]]]|N|$O|$5|P|Q|R|E|$S|T]]|U|$5|P|Q|R|E|$S|V]]]]

If you want to avoid writing <code>LIKE</code> many times, and you're working with MSSQL, take a look at <a href="http://msdn.microsoft.com/en-us/library/ms174979.aspx" rel="nofollow">temporary tables</a> or <a href="http://msdn.microsoft.com/en-us/library/ms188927.aspx" rel="nofollow">table variables</a>.

The general idea would be to put all search terms (firstname - lastname combinations) in a temp table / table variable, and then execute a query which checks whether <code>dm_user.description</code> containts at least one of the search terms.

<pre><code>SELECT DISTINCT u.id
FROM dm_users AS u, #tmp as t
WHERE dm_users.description LIKE N'%' + t.searchterm + '%'
</code></pre>

blocks|key|734380|text|是否可以使用动态查询并让Server写入这些字符串100次？|type|unstyled|depth|inlineStyleRanges|entityRanges|data|734381|--DROP+TABLE+#User
--+This+is+an+EXAMPLE:+keep+using+your+names+source
CREATE+TABLE+#User(Id+int,+Name+varchar(50))
INSERT+INTO++#User+VALUES+(1,+'First')
INSERT+INTO++#User+VALUES+(2,+'Second')
--+...+and+so+on

DECLARE+@Query+nvarchar(max)
SELECT++@Query+=+'SELECT+*+FROM+DM_USER+WHERE+1=0'+%2B
++++++++(
++++++++++++SELECT++'
+OR+Description+LIKE+'+%2B+QUOTENAME('%25'+%2B+Name+%2B+'%25',+'''')
++++++++++++FROM++++#User
++++++++++++FOR+XML+PATH+(''),+TYPE
++++++++).value('.',+'nvarchar(max)')

PRINT+++'@Query+=+'+%2B+ISNULL(@Query,+'NULL')
EXEC++++sp_executesql+@Query|code-block|syntax|javascript|734382|结果：|734383|@Query+=+SELECT+*+FROM+DM_USER+WHERE+1=0
+OR+Description+LIKE+'%25First%25'
+OR+Description+LIKE+'%25Second%25'|734384|entityMap^0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|M|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|N|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|O|8|@]|9|@]|A|$]]|$1|I|3|J|5|D|7|P|8|@]|9|@]|A|$E|F]]|$1|K|3|-4|5|6|7|Q|8|@]|9|@]|A|$]]]|L|$]]

Can use use dynamic queries and let SQL Server to write those strings 100 times?

<pre><code>--DROP TABLE #User
-- This is an EXAMPLE: keep using your names source
CREATE TABLE #User(Id int, Name varchar(50))
INSERT INTO #User VALUES (1, 'First')
INSERT INTO #User VALUES (2, 'Second')
-- ... and so on

DECLARE @Query nvarchar(max)
SELECT @Query = 'SELECT * FROM DM_USER WHERE 1=0' +
 (
 SELECT '
 OR Description LIKE ' + QUOTENAME('%' + Name + '%', '''')
 FROM #User
 FOR XML PATH (''), TYPE
 ).value('.', 'nvarchar(max)')

PRINT '@Query = ' + ISNULL(@Query, 'NULL')
EXEC sp_executesql @Query
</code></pre>

Result:

<pre><code>@Query = SELECT * FROM DM_USER WHERE 1=0
 OR Description LIKE '%First%'
 OR Description LIKE '%Second%'
</code></pre>

I need to write a query to get a list of users where their fullname is in an attribute named description. User names are kept in that attribute in any of the format:-

<ul>
<li>LASTNAME Firstname</li>
<li>LASTNAMEFirstname (without space)</li>
<li>FirstnameLastname</li>
</ul>

In such a scenario if I need to search a given list of users(around 100) in that attribute, I have to write query like
<code>select * from dm_user where UPPER("description") like '%FIRSTUSER_FIRSTNAME%' OR UPPER("description") like '%SECONDUSER_FIRSTNAME%'</code> and so on..

Is their a way I can do things more simply.I hate writing <code>*UPPER("description") like*</code> 100 times.(Please suggest standard sql query).
I need to run this query on Documentum and MSSQL.

I just want to have something like 

{

<pre><code>select * from dm_user 
where UPPER("description") 
like IN ('%FIRSTUSER_FIRSTNAME%','%SECONDUSER_FIRSTNAME%');
</code></pre>

but its not available in documentum}

Query to find users

翻译质量差，导致语言生硬或混乱。

没有提供实际的解决方法或示例。

解答不清晰，无法理解或解决问题。

页面排版不美观，阅读体验差。

文章

问答

视频

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

腾讯iOA零信任安全管理系统专区

腾讯云架构师技术同盟交流圈

腾讯云数据库专区

腾讯云顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋

腾讯云代码助手

云原生构建

TAPD 敏捷项目管理

Cloud Studio

SDK中心

API中心

命令行工具

涵盖代码开发、场景应用、自动测试全流程，助你从零构建专属AI助手

一站式MCP教程库，解锁AI应用新玩法

我需要编写一个查询，以获得名为description的属性中的用户列表。用户名以任何格式保存在该属性中：-LASTNAMELASTNAMEFirstname (无空间)FirstnameLastname在这种情况下，如果我需要在该属性中搜索给定的用户列表(大约100个)，我必须编写类似select * from dm_...

问查询查找用户
EN

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问查询查找用户EN