[SOLVED] IS NOT EMPTY

[rubing]

I need something very similar to 'IS NOT NULL' in my query.  Except I also want to exclude empty strings.

 

SELECT Band, BandSite
FROM 
MusicEvents
LEFT JOIN Bands ON Musica_Events.Band = Bands.Band
WHERE BandSite IS NOT NULL 

 

 

 

[rubing]

Just found a work around by matching with wildcards (e.g. since i'm retrieving urls - WHERE BandSite LIKE 'http%' )