如何从表中的列中只有一个单词 [英] How to get only having one word in a column from a table

问题描述

我有一个表员工，名字是一栏。



我想让所有名字中只有一个字的员工。像Ram一样，约翰不喜欢Ram charan，John smth ..

解决方案

假设单词被空格分隔，那么你可以使用：

  WHERE 名称 NOT   LIKE  ' ％[^]％[^]％' 

它将返回一组在其他单词之间没有空格的名称。

解决方案1和2非常好。



另一种方法是使用 CHARINDEX [ ^ ]功能。

  SELECT  LTRIM（RTRIM（ [名称]）） AS  [名称] 
  FROM  TableName 
  WHERE  CHARINDEX（' '，LTRIM（RTRIM（[Name]）））=  0  

注：

LTRIM [ ^ ]和 RTRIM [ ^ ]函数用于删除前导和结束空格。

推荐此链接



SQL LIKE运算符 [ ^ ]



问候..：）

I have a table employee in that Name is a column.

I want to get all employees who are having only one word in their name. Like Ram,john not like Ram charan, John smth..

解决方案

Assume the words are got separated by space, then you can use:

WHERE Name NOT LIKE '%[^ ]% [^ ]%'

It will return set of names not having a space between other words.

Solution 1 and 2 are very good.

Another way is to use CHARINDEX[^] function.

SELECT LTRIM(RTRIM([Name])) AS [Name]
FROM TableName
WHERE CHARINDEX(' ', LTRIM(RTRIM([Name]))) = 0

Note:
LTRIM[^] and RTRIM[^] function is used to remove leading and ending spaces.

Refer this link

SQL LIKE Operator[^]

Regards..:)

这篇关于如何从表中的列中只有一个单词的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！