GeoffB wrote:A new format for the titles of sales ads is about to be introduced. Titles will start with a country digraph and a price padded out to 5 digits, to enable sorting by country and price. Full guidance on this will be provided in the next few days when the details are finalized. In the meantime you may notice some titles have already be changed as part of a trial. All will be explained soon!
I'm not sure I understand the rationale for changing the format. Do you want to add drop-down sorting options? Seems like the cleanest way to do this would be to construct a form for posting these listings, with fields for country, price, etc. and a free-text field for the description. Your DB table would then match the desired functionality, rather than trying to impose functionality on a sub-optimal schema.
Remember Anthony Weller, please help. Contact myself or Aaron Green for details.