SQL Count Query

2003-01-18 Thread Jefferey Donnici
I've got a table whose structure looks like this: CREATE TABLE IF NOT EXISTS calc_hits (id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, hit_date DATETIME NOT NULL, PRIMARY KEY (id)) AUTO_INCREMENT = 1; On a web site, a row gets inserted into this table whenever a visitor uses a certain tool o

FULLTEXT yields inconsistent results

2002-09-09 Thread Jefferey Donnici
I'm just getting started with FULLTEXT indexes for a table and am seeing some very off-base results. While it may be something I'm doing, I didn't see anything in the online manual to indicate why these results would be so bizarre. Here is a test table I've created: create table ft_test (id s