MySQL Replace Null with an Empty String

Question

I have this table

I'am trying to get all the titles of every user id and convert null to an empty string.

I tried using this

SELECT IFNULL(title, '') FROM table WHERE user_id = 1

But it says that multiple rows returned, when I try 2 it returns a result.

Is there a way to convert all null relut to empty string if ther more than 1 result? Thanks.

If its just the conversion you want, UPDATE table SET title='' WHERE title IS NULL — danblack
– danblack, Commented Aug 28, 2021 at 7:26
What result would you expect for user_id 1 if there would be no null value in your input table? Just one of the input rows? A concatenation of all titles? Is it not possible in your domain to have more than one non-null title per user? — divisionby0
– divisionby0, Commented Aug 28, 2021 at 7:29
Does this answer your question? MySql Query Replace NULL with Empty String in Select — Elias
– Elias, Commented Jun 24, 2022 at 9:20

Sneha Ashtekar · Accepted Answer · 2021-08-28 07:30:07Z

1

You can use COALESCE() to replace NULL with an empty string.

answered Aug 28, 2021 at 7:30

Sneha Ashtekar

1341 gold badge1 silver badge6 bronze badges

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

1 Comment

you should show a little more in an answer, like how it matches to the question.

digitalbarista · Accepted Answer · 2022-02-12 17:47:01Z

0

You can find a detailed answer on the following link.

Hope it resolves your issue.

Thanks

answered Feb 12, 2022 at 17:47

digitalbarista

12 bronze badges

Try to provide at least a summary of the solution so this is not a link-only-answer. You can read more about it here: meta.stackoverflow.com/tags/link-only-answers/….