I have promo codes with 6 characters each. Like so: AOIE0S and so on... now I dont want this particular one showing up in my results because it's got both a "Zero" and an letter "O". I dont want any promo codes with zeroes or the letter o's showing up in my result set. I tried my query but it won't work.
---------- select code from promo_tbl where code not like '_0' and code not like '_o' ----------