Like most things mySQL, limitations are more likely to be hardware, OS, and memory dependent than any set limits.

If you have tables 150 columns wide, and that many "and's" or "or's" in your selects, it may be a good time to re-think your database structure and split it up into multiple tables. Look into database normalization.