Selecting non empty MySQL coloumn

[Anon]

Hi,

I am trying to select rows that have non-empty info coloumns.

I have this songs table, I need to list only songs which have the info coloumn filled out.

Any help would be apprecaited.

Thanks in advance.

[Anon]

What about:

SELECT * FROM table WHERE info<>'';

or maybe (if you allow NULLs):

SELECT * FROM table WHERE info NOT NULL;

probably a few other ways to do it depending on how your table is made.

[Anon]

Thanks a lot <> '' worked 🙂