Is there any sql-query to check the value is exist or not in db table

Question

In my database table have this value,i have to check this email value 'abc@gmail.com' is exist in the database or not.

abc@gmail.com
edf@dfg.com
xyz@abcinfo.com
12345@fdfg.com

If 'abc@gmail.com' value is exist in the database table, output is true else false, so how to write the query for this to achieve?

thanks Kumar

thanks for comments i will improve my questions and how to ask. — Kumar Shanmugam, Nov 19 '13 at 09:34

score 2 · Accepted Answer · answered Nov 14 '13 at 12:22

2

You can do something as simple as select CASE WHEN count(1) > 0 THEN 'true' ELSE 'false' END from table where email = 'abc@gmail.com'

But you should give some more information for a beater answer.

answered Nov 14 '13 at 12:22

Paraíso

score 2 · Answer 2 · answered Nov 14 '13 at 12:25

2

you can write query like

SELECT IF(COUNT(*) >0, TRUE,FALSE)as response FROM <tablename> WHERE emailid='edf@dfg.com';

answered Nov 14 '13 at 12:25

developerCK

1

thanks this code is improve my programming knowledge and is useful too... – Kumar Shanmugam Nov 14 '13 at 12:34
@developerCK, Thanks for this post, This piece I want. – CJ Ramki Nov 14 '13 at 12:34
hi this is only show 1 only if mutli time the mail id exist in the table. So to get the no. of time the mail id exist in table – Kumar Shanmugam Nov 14 '13 at 12:44
SELECT IF(COUNT(*) >0, TRUE,FALSE)as response, count(*) as nooftimes FROM WHERE emailid='edf@dfg.com', it is * b/w count parenthesis; – developerCK Nov 14 '13 at 12:56

score 1 · Answer 3 · answered Nov 14 '13 at 12:26

1

select exists(
   SELECT 1 FROM <tableName> WHERE email LIKE 'abc@gmail.com'
)

answered Nov 14 '13 at 12:26

mauretto

3 Answers3