Text data from mySQL nullable table

[sbh]

I am querying for some text data in a nullable table to show in a plain table.

Ok as long as table doesnt contain any nulls, but when it happens the following error appear:

sql: Scan error on column index 0: unsupported Scan, storing driver.Value type into type *string

I am using grafana-4.6.3.linux-x64.
Any ways around this?

[svenklemm]

SELECT coalesce(nullable_column,'') AS nullable_column FROM table

This will replace NULL values with empty string

[sbh]

@svenklemm

SELECT coalesce(nullable_column,‘’) AS nullable_column FROM table

That did it.
Big cheers to you Sven!