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
