86Stang Posted February 15, 2009 Share Posted February 15, 2009 The title pretty much says it all -- how do I do a query my database table to return all records that don't have an @ symbol in a particular field? Quote Link to comment https://forums.phpfreaks.com/topic/145318-solved-how-to-do-a-query-for-records-that-does-not-have-an/ Share on other sites More sharing options...
86Stang Posted February 15, 2009 Author Share Posted February 15, 2009 I believe I figured it out: SELECT * FROM table WHERE field NOT LIKE '%@%'; Quote Link to comment https://forums.phpfreaks.com/topic/145318-solved-how-to-do-a-query-for-records-that-does-not-have-an/#findComment-762883 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.