I have actually run into limits with query lengths, but not of the entire query itself. I have found that MySQL does not like lists "... where myfield IN (3,4,2,7,9,...)" to be longer than 255.