mysql set value to empty if specific field is not empty

Question

I have created this sql select query:

SELECT subscription_new_projects.banners, subscription_new_projects.banner_link
FROM subscription_new_projects
WHERE be_famous_id =32
AND now( ) < end_date
ORDER BY subscription_new_projects_id DESC

and getting this sql result:

enter image description here

Now I want to set banners field empty, If banner_link is not empty.

I want this result:

enter image description here

My SQL Fiddle: Example

Any Idea how to do this?

Thanks.

Abhik Chakraborty · Accepted Answer · 2015-04-30 10:47:40Z

2

You can use case-when

SELECT 
case 
when 
  subscription_new_projects.banner_link <> '' then '' 
  else subscription_new_projects.banners 
end as banners,  
subscription_new_projects.banner_link
FROM subscription_new_projects
WHERE be_famous_id =32
AND now( ) < end_date
ORDER BY subscription_new_projects_id DESC

answered Apr 30, 2015 at 10:47

Abhik Chakraborty

44.9k6 gold badges56 silver badges63 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Mr.Happy Over a year ago

Working perfect for me. Thanks :)

Ullas · Accepted Answer · 2015-04-30 10:48:20Z

0

Use CASEstatement.

Query

SELECT 
CASE WHEN subscription_new_projects.banner_link != ''
THEN NULL 
ELSE subscription_new_projects.banners
END AS banners,
subscription_new_projects.banner_link
FROM subscription_new_projects
WHERE be_famous_id =32
AND now( ) < end_date
ORDER BY subscription_new_projects_id DESC;

Fiddle demo

answered Apr 30, 2015 at 10:48

Ullas

11.6k5 gold badges36 silver badges52 bronze badges

Collectives™ on Stack Overflow

mysql set value to empty if specific field is not empty

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related