Matthew,
Monday, September 02, 2002, 10:25:40 PM, you wrote:
[skip]
thd->>query at 0x88b3798 = SELECT DISTINCT * FROM b2posts WHERE 1=1 AND
MM> ID = 124 AND ((post_title LIKE '%%') OR (post_content LIKE '') OR
MM> (post_title LIKE '%%') OR (post_content LIKE '%%')) AND post_date <
MM> '2002-08-3
| 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'?
You're right, here it is:
CREATE TABLE b2posts (
ID int(10) unsigned NOT NULL auto_increment,
post_author int(4) NOT NULL default '0',
post_date datetime NO
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:
Here is the evil query:
SELECT DISTINCT * FROM b2posts WHERE 1=1 AND ID = 124 AND ((post_title
LIKE '%%') OR (post_content LIKE '') OR (post_title LIKE '%%') OR
(post_content LIKE '%%')) AND post_date < '2002-08-31 14:31:55' AND
post_category > 0 ORDER BY post_date DESC
Here's a structure dump of
