how can I shut off "more"?

When I run a query, and the number of lines exceeds what the screen can hold,  the results seem to get piped into “more” (or “less”).  How can I turn that off and just have everything stream out without stopping?  I tried –echo-all, but that doesn’t seem to do the trick.

Thanks in Advance !