MYSQL Null Empty IsSet

Question

There is a field called image_src in my table. I would like to get something like a boolean value of 1 if the field contains something ( not null or empty ) else 0 other wise. So is there any function to do that? In PHP we have isset()

Something like :

Select isset(image_src) from table

Aurelio De Rosa · Accepted Answer · 2011-10-25 12:47:26Z

4

Take a look here:

SELECT if(image_src is null OR image_src = '', 0, 1) FROM table

This line will check if the field is null or empty.

edited Oct 25, 2011 at 12:47

answered Oct 24, 2011 at 11:11

Aurelio De Rosa

22.2k8 gold badges51 silver badges71 bronze badges

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

Comments

michael667 · Accepted Answer · 2011-10-24 11:11:52Z

3

MySQL has the isnull function.

answered Oct 24, 2011 at 11:11

michael667

3,26026 silver badges32 bronze badges

1 Comment

michael667 Over a year ago

There is no dedicated function for that. If you want to check both, you should use a CASE expression.

N.B. · Accepted Answer · 2011-10-24 11:12:33Z

2

SELECT IF(ISNULL(image_src), 0, 1) AS aliased_value FROM table

answered Oct 24, 2011 at 11:12

N.B.

14.1k3 gold badges47 silver badges56 bronze badges

Collectives™ on Stack Overflow

MYSQL Null Empty IsSet

3 Answers 3

Comments

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related