Crapola.
When you enter a query (may be artist or album, but I had one in the title - Aerosmith, Trip Hoppin') with an apostrophe, it spits out an error. There's really no reason to have any problems with apostrophes, when there are escape protocols a'plenty to use, like in the following:
SELECT * FROM `users` WHERE COMMENT = 'I'm smart';
would be an error because the ' in "I'm" would close the quotes for 'I'm smart'. To get around this, add slashes - in MySQL, that's the ridiculously long-named "mysql_real_escape_string()" function, which I typically alias to "mres()" in my code. That would change the string to:
SELECT * FROM `users` WHERE COMMENT = 'I\'m smart';
It's just a matter of escaping.
As for the regexp thing, the error I got on the search page regarding the apostrophe is a regular expressions error. I was saying you didn't need to use regular expressions to begin with
