Zergman Posted October 23, 2008 Share Posted October 23, 2008 Sorry if this might sound simple, but can't figure this one out. I have a column in a table that has various entries Example Option1 Option2 Option3 ... etc. What im trying to do is build a query that searches for all records excluding Option1. Just need a tally of how many records don't have Option 1 in them. Can't figure out how to do this ??? Link to comment https://forums.phpfreaks.com/topic/129838-solved-excluding-records-from-search/ Share on other sites More sharing options...
trq Posted October 23, 2008 Share Posted October 23, 2008 SELECT COUNT(fld) AS tally FROM tbl WHERE fld != 'Option1'; Link to comment https://forums.phpfreaks.com/topic/129838-solved-excluding-records-from-search/#findComment-673107 Share on other sites More sharing options...
Zergman Posted October 23, 2008 Author Share Posted October 23, 2008 Beautiful, thanks for the help! Link to comment https://forums.phpfreaks.com/topic/129838-solved-excluding-records-from-search/#findComment-673113 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.