Matthew, Saturday, August 31, 2002, 10:41:27 PM, you wrote: MM> Here is the evil query: MM> SELECT DISTINCT * FROM b2posts WHERE 1=1 AND ID = 124 AND ((post_title MM> LIKE '%%') OR (post_content LIKE '') OR (post_title LIKE '%%') OR MM> (post_content LIKE '%%')) AND post_date < '2002-08-31 14:31:55' AND post_category > 0 ORDER BY post_date DESC
MM> Here's a structure dump of the table it's trying to select from: MM> CREATE TABLE b2comments ( MM> comment_ID int(11) unsigned NOT NULL auto_increment, MM> comment_post_ID int(11) NOT NULL default '0', MM> comment_author tinytext NOT NULL, MM> comment_author_email varchar(100) NOT NULL default '', MM> comment_author_url varchar(100) NOT NULL default '', MM> comment_author_IP varchar(100) NOT NULL default '', MM> comment_date datetime NOT NULL default '0000-00-00 00:00:00', MM> comment_content text NOT NULL, MM> comment_karma int(11) NOT NULL default '0', MM> PRIMARY KEY (comment_ID) MM> ) TYPE=MyISAM; May be I'm blind, :-) but you provided dump of another table than you used in the query. What is the structure of table 'b2posts'? What type of errors do you get? Is there anything in the error log? What OS do you use? How did you installed MySQL: from binary or from source? MM> This is my first time posting to the list, so do you need any more MM> information? I'll be happy to provide any other information needed, PHP MM> or SQL code, etcetera. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
