Re: Full text search containing email address

[Rick James]

Do these on each instance:
SHOW CREATE TABLE legal_matter;
SHOW VARIABLES LIKE '%ft%';
and check for differences. In particular, check the table for 'ENGINE'.

> Error Code: 1064. syntax error, unexpected '@', expecting $end

What client are you using? If it is Perl, you may need to escape the @.

> I have no idea if it has anything to do with the different OS versions

It seems unlikely.

5.6.4 introduced:
"The new @ operator allows proximity searches for terms that are near each other in the document."
Do some research on that.