How to make no rows display in mysql when the IN is empty

Question

I have used the following query to get the data from database its working fine when the IN () is not empty but how can i restrict it as displaying no rows When my IN is empty

SELECT `id`, `date`, `user`, `type`, `module`, `action`, `ip_address`, `log` 
FROM `task_logs` 
WHERE `type`='E' AND ((`task` IN () AND (`module` = 'task' OR `module` = 'plan')) OR (`task` IN (35) AND `module` = 'regular_task')) 
ORDER BY `id` DESC

I imagine your problem is the `or` not the `in`. – shawnt00 Jun 29 '15 at 05:49 — shawnt00, Jun 29 '15 at 05:49

score 1 · Accepted Answer · answered Jun 29 '15 at 05:47

1

Working in Postgres:

select *
from <table>
where id in (null)

Edit: But you have to take care that id is never null though :-)

answered Jun 29 '15 at 05:47

Smutje

17,733
4
24
41

Even if `id` is null `id in (null)` will fail anyway – Giorgos Betsos Jun 29 '15 at 05:49
Ya the ID is a primary key and ur answer is correct...! – Raja Manickam Jun 29 '15 at 05:49
2

If `id` is nullable or not it does not make any difference – Giorgos Betsos Jun 29 '15 at 05:57
Ya i got ur point and its working fine thanx fr ur help friend – Raja Manickam Jun 29 '15 at 05:59

How to make no rows display in mysql when the IN is empty

1 Answers1