Hello All,
Just to add some additional info to our problem. If I do a simple query:
select * from bus_search where match(title,keywords) against('Best Car Deals')
I get nothing! and its there! Is it possible the table is not set up properly??
Or I'm I wishing something here??
Table Info:
CREATE TABLE bus_search (
bus_id int(8),
title varchar(200),
keywords TEXT,,
cat_prefix char(2),
FULLTEXT (keywords,title)
);
INSERT INTO bus_search
(bus_id,tite,keywords,cat_prefix)
VALUES('9','Dealersecrets, Inc.',
'Secrets to the Best Car Deals negotiating prices book with tips for buying',
'VE');
EXPLAIN SELET * FROM bus_search
WHERE MATCH(title,keywords) AGAINST('Best Car Deals')
----------------------------------------------------
Comments:
Impossible WHERE noticed after reading const tables
>>I posted a question regarding a search query we are trying to get to work, and
>>was hoping someone can tell why this query doesn't work. It should return
>>results as all the search criteria is there in the tables( for test purposes)
>>
>>QUERY:
>>SELECT bi.bus_name,bi.address,bl.city,bl.state,
>>bl.zipcode,h.hr_descript,bi.phone,bi.comments,bi.unique_url,
>>CONCAT(bi.contact_fname," ",bi.contact_lname) AS name
>>FROM bus_info bi,bus_search bs,bus_loc bl,hours h
>>WHERE MATCH (bs.title,bs.keywords) AGAINST ('prices')
>>AND bs.cat_prefix = 'VE'
>>OR bi.category = 'VEAD'
>>AND bs.bus_id = bi.info_id
>>AND bi.info_id = bl.loc_id AND h.hr_code = bi.hrs_open
>>GROUP BY bi.bus_name
>>
>>Is their a reason why the 'MATCH (bs.title,bs.keywords) AGAINST ('book')'
>>in this query will not return any results?
>>
>>Any help/suggestion would be greatly appreciated. We are using MySQL 3.23.33
>>
>>TIA :)
>>
>>Mike(mickalo)Blezien
>>========================================
>>Thunder Rain Internet Publishing
>>Providing Internet Solutions that work!
>>http://www.thunder-rain.com
>>Tel: 1(225) 686-2002
>>=========================================
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>---------------------------------------------------------------------
>>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
>>
Mike(mickalo)Blezien
========================================
Thunder Rain Internet Publishing
Providing Internet Solutions that work!
http://www.thunder-rain.com
Tel: 1(225) 686-2002
=========================================
---------------------------------------------------------------------
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
