SELECT * FROM tablename WHERE key = 12345 ORDER BY version; #### SELECT * FROM tablename WHERE key LIKE '12345,%' ORDER BY key; #### SELECT * FROM tablename o WHERE key = ? AND version = ( SELECT max(version) FROM tablename i WHERE i.key = o.key ) #### SELECT * FROM tablename WHERE key = ( SELECT max(key) FROM tablename WHERE key LIKE '$key,%' )