您可以使用like运算符，对于“Tom Checked”示例，您可以使用以下代码

SELECT * FROM NAMES where NAMES like '%Tom%' and NAMES like '%Checked%'

您只需要使用like运算符：

SELECT * FROM NAMES WHERE ColumnName LIKE '%Tom%' and ColumnName LIKE '%Checked%'

可以使用存储过程进行动态搜索

USE [DatabaseName]
GO

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- usp_GetReportInfo 3,17,65

Create PROC [dbo].[usp_SeahcByName]
@name nvarchar
AS BEGIN

   SELECT   *
FROM            NAMES
WHERE        (NAMES LIKE '%name%')
END

then Just Execute this Store Procedure With Value
EXEC usp_SeahcByName

或者您可以使用原始查询Like

SELECT   * FROM NAMES WHERE        (NAMES LIKE '%Tom Checked%')

假设您使用的是mysql/mssql/access或类似工具，则您拥有：

select * from [NAMES] where [name] like '%Tom User Checked%

以筛选出包括“Tom User Checked”在内的名称字符串

select * from [NAMES] where [name] like '%Jane'

过滤掉以“Jane”开头的姓名字符串

select * from [NAMES] where [name] like 'Only PIN%'

过滤掉以“Only PIN”结尾的名称字符串