c_pattle Posted November 19, 2010 Share Posted November 19, 2010 I was just wondering if this is a way that you can exclude certain rows from a MySQL query. For example if I have 10 records each with a unique id, is there anyway I can get all of the records except record 5? Thanks for any help. Quote Link to comment https://forums.phpfreaks.com/topic/219191-excluding-results-from-query/ Share on other sites More sharing options...
litebearer Posted November 19, 2010 Share Posted November 19, 2010 what is 'unique' about the record(s) to be excluded? perhaps... WHERE some_field != some_value, or conversely, WHERE some_field = some_value Quote Link to comment https://forums.phpfreaks.com/topic/219191-excluding-results-from-query/#findComment-1136624 Share on other sites More sharing options...
ManiacDan Posted November 19, 2010 Share Posted November 19, 2010 You should probably read the first 4-5 chapters of the MySQL manual. Quote Link to comment https://forums.phpfreaks.com/topic/219191-excluding-results-from-query/#findComment-1136629 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.