From: Arthur Fuller Date: September 23 2012 10:38pm Subject: Re: How to block SELECT * FROM table; but not SELECT * FROMT table WHERE...; List-Archive: http://lists.mysql.com/mysql/228239 Message-Id: MIME-Version: 1.0 Content-Type: multipart/alternative; boundary=f46d042de3e38eba8404ca6623a5 --f46d042de3e38eba8404ca6623a5 Content-Type: text/plain; charset=ISO-8859-1 Tim, I think you misunderstood the question. Daniel wants to block Select queries that ask for all rwows, and permit only queries that ask for some rows, as restricted by the Where clause. Unfortunately, I don't think that can be done. But I'm not certain of that; there might be a trick. Arthur www.artfulsoftware.com On Sun, Sep 23, 2012 at 3:50 PM, Tim Pownall wrote: > select * from table where column=value means it will return only rows that > match. as long as you have proper indexing there should not be any issues. > > On Sun, Sep 23, 2012 at 1:23 PM, Luis Daniel Lucio Quiroz < > luis.daniel.lucio@stripped> wrote: > > --f46d042de3e38eba8404ca6623a5--