Question: In case I only provide a single value, are the following `sql` statements equivalent (eg in terms of performance)?

```
SELECT * FROM mytable where lastname IN(:lastnames);
SELECT * FROM mytable where lastname = :lastname;

```

Background: I have service that should serve a list, and a service that serves a single result. Now I thought why creating two database query endpoints, if I could achieve the same thing with just one query (means: also a single result could be queried by using the `IN` clause).

Answer: 
i tried it on my mariaDB database on a small table with hundred of records and the query with IN is a bit slower than the first one (which is to be expected) but we are talking of 0.02 sec difference
Use This Query.
It May Be Solve Your Problem.

SELECT \* FROM mytable where lastname IN(SELECT lastname FROM mytable where lastname = :lastname);