如何使用单个sql语句将输入与表的两列进行比较？

I want to use only one single query to compare the given name with the two fields of database named FirstName, LastName.

我想只使用一个查询来将给定名称与名为FirstName,LastName的数据库的两个字段进行比较。

SELECT id FROM admin WHERE FirstName AND LastName ='test last';

This query is wrong, and I would like to correct it. Can you help me?

这个查询是错误的,我想纠正它。你能帮助我吗?

test is FirstName and last is the LastName

test是FirstName,last是LastName

5 个解决方案

#1

SELECT id FROM admin WHERE Firstname+' '+Lastname = 'test last'

SELECT id FROM admin WHERE Firstname+Lastname = 'testlast'

For MySQL it's:

对于MySQL,它是:

SELECT id FROM admin WHERE CONCAT(Firstname,Lastname) = 'testlast'

SELECT id FROM admin WHERE CONCAT(Firstname,' ',Lastname) = 'test last'

#2

(updated)

I think you're looking for, if you're using SQL Server

如果您使用的是SQL Server,我认为您正在寻找

SELECT id 
FROM admin 
WHERE FirstName + ' ' + LastName = 'test last';

or if you want a generic query to check all situations like this from your tables

或者如果你想要一个通用查询来从表中检查这样的所有情况

SELECT id 
FROM admin 
WHERE FirstName + ' ' + LastName = CONCAT(FirstName, ' ', LastName)

#3

try this

select id from admin where Firstname ='test' and LastName='last'

从admin中选择id,其中Firstname ='test',LastName ='last'

#4

Try This..

SELECT id FROM admin WHERE FirstName ='test' AND LastName = 'last';

You have to Use 'AND' Operator..

你必须使用'AND'运算符..

#5

In Sybase it works as follows:

在Sybase中,它的工作方式如下:

SELECT id
FROM admin
WHERE FirstName LIKE "test"
  AND LastName  LIKE "last"

#1

SELECT id FROM admin WHERE Firstname+' '+Lastname = 'test last'

SELECT id FROM admin WHERE Firstname+Lastname = 'testlast'