Re: optimizing "not empty" selections

Michael Monashev <[EMAIL PROTECTED]> wrote on 07/26/2005 04:41:28 PM: > Hello, > > How to optimize != statement? > > SELECT * FROM table1 WHERE char_255_column != ''; > > How to fast select all rows, where CHAR(255) NOT NULL column not > empty? > > > > Sincerely, > Michael, You could

optimizing "not empty" selections

Hello, How to optimize != statement? SELECT * FROM table1 WHERE char_255_column != ''; How to fast select all rows, where CHAR(255) NOT NULL column not empty? Sincerely, Michael, http://xoib.com/ http://3d2f.com/ http://qaix.com/ http://ryxi.com/ http://gyxe.com/ http://gyxu.com/