I have a regex which works in Perl, but not in Mysql and I was wondering what might be causing the problem. Here it is: ([KR-]\.[^KR]*?[KR][\@|\#]([^KR]*?[KR][\@|\#])*\.)|([KR-]\.[^KR]*?[KR][\@|\#]([^KR]*?[KR][\@|\#])*[^KR]*?\.\-)|([KR-]\.([^KR]*?[KR][^\@|\#])*[^KR]*?[KR]+\.)|([KR-]\.([^KR]*?[KR][^\@|\#])*[^KR]*?\.\-)The error that it gives is ...