Drongo_III Posted December 17, 2014 Share Posted December 17, 2014 Hi Guys I have a table which in it's shortened form has the following columns: id | postID | title | content | version The column for postID has a number that can be shared by multiple rows - differentiated by version number. I want to run a query to select all records that are like a given keyword (i.e. %LIKE%) but where results share the same postID I only want to return the highest version number for that record. The difficulty is some records may have multiple version numbers that match the like statement and some may have only one. So this variance with the LIKE search is causing me some confusion. I've tried this in a few ways using a sub-query but for the life of me I cannot work out how to do it. Any help would be appreciated, Drongo Quote Link to comment Share on other sites More sharing options...
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.