id,summary,reporter,owner,description,type,status,priority,milestone,component,version,severity,resolution,keywords,cc,mlocked 5452,Improvement mythweb music module (probably also worth considering for mythmusic),jonathan@…,Rob Smith,"As I grew tired of browsing my extensive music catalog using mythweb and having a large list in under T starting with 'the' I started investigating to find a method to have the interface ignore the 'the' prefix. As I was unable to do it in one query because of errors in the like part of the query I created a custom view as shown in the attachment and modified the query that links from the letters in the browse mode to look at the view instead of the music_artists table. I have no idea of using views is allowed or not, but it works very nicely in my case. I have hardcoded two of the prefixes I was bothered by in this example, but I could imagine that different languages (as not all music has english titles) have other prefixes so I suggest some sort of coniguration option for that, perhaps in a table so we can generate the like statement based on the users wishes. I also suggest to insert an analogue method into mythmusic (the method to strip 'the' is already hard coded in the source), but this way it is more flexible for user customization and extension. ",enhancement,closed,minor,unknown,mythweb,unknown,medium,fixed,,,0