sql construct condition with if statement mysql -
i want construct such sql condition. have table car, has such fields id_status
, id_category
, storage_address
. need select cars id_status
in (2,4) , if id_category = 4
need check field storage_address
not null or empty. how make it? should use sql if
statement? need like:
select * car id_status in (2,4) , if(id_category = 4,storage_address not null,'1=1')
try this:
select * car id_status in (2,4) , if( id_category = 4, storage_address not null, 1 )
simply put, not need string '1=1'
, plain 1
truthy value.
or can
select * car id_status in (2, 4) , ( id_category != 4 or storage_address not null )
Comments
Post a Comment