rubing Posted May 31, 2008 Share Posted May 31, 2008 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 Link to comment https://forums.phpfreaks.com/topic/108076-solved-is-not-empty/ Share on other sites More sharing options...
rubing Posted May 31, 2008 Author Share Posted May 31, 2008 Just found a work around by matching with wildcards (e.g. since i'm retrieving urls - WHERE BandSite LIKE 'http%' ) Link to comment https://forums.phpfreaks.com/topic/108076-solved-is-not-empty/#findComment-553951 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.