It sets the sorting of the server:
Splits into few parts:
latin1 makes the server treat strings using charset latin 1, basically ascii
CP1 stands for Code Page 1252
CI case insensitive comparisons so 'ABC' would equal 'abc'
AS accent sensitive, so 'ü' does not equal 'u'
I hope this would help you.
If you want to get more insights into SQL, check out this SQL Course from Intellipaat.