0 votes
1 view
in SQL by (22.4k points)

I'm trying to find out if a row exists in a table. Using MySQL, is it better to do a query like this:

SELECT COUNT(*) AS total FROM table1 WHERE ...

and check to see if the total is non-zero or is it better to do a query like this:

SELECT * FROM table1 WHERE ... LIMIT 1

and check to see if any rows were returned?

In both queries, the WHERE clause uses an index.

1 Answer

0 votes
by (40.3k points)

Use this code:

SELECT EXISTS(SELECT * FROM table1 WHERE Condition)

you can refer to the documentation.

As Per the comment use this code:

SELECT EXISTS(SELECT 1 FROM table1 WHERE Condition)

Related questions

+2 votes
1 answer
0 votes
1 answer
0 votes
1 answer
0 votes
1 answer
Welcome to Intellipaat Community. Get your technical queries answered by top developers !


Categories

...