Regular expressions? Yes and no, I think. You could perform the actual comparison like that in Perl but I don’t think you can be that rich in SQL (SlimServer 6 offloads the actual searching to an SQL query). When I first cobbled it together for SlimServer 5.4.1 I could have saved myself some trouble by doing it your way, though.
I did look at whether there was some ‘tr’-like SQL functionality that I could use in a similar way, but came to the conclusion that there wasn’t anything SQL-portable enough and anything that generates column values dynamically like that would kill performance because it would require a full table-scan and wouldn’t take advantage of index searching. So, I think that it’s best to pre-process the strings at database build-time to simplify the SQL searching later on. -- hickinbottoms --- Stuart _______________________________________________ Discuss mailing list [email protected] http://lists.slimdevices.com/lists/listinfo/discuss
