Try to search in keyword table:
select * from keywords WHERE MATCH(keyword_txt) AGAINST ('$radio_keyword' IN BOOLEAN MODE);
If it works the problem is in the join. Santino
$query = "SELECT page.* FROM `page` LEFT JOIN `keywords` USING
(`page_id`) WHERE MATCH (`keywords`.`keyword_txt`) AGAINST
('$radio_keyword' IN BOOLEAN MODE)";
At 20:05 -0400 15-10-2004, leegold wrote:
On Fri, 15 Oct 2004 15:00:10 -0700, "Chris W. Parker" <[EMAIL PROTECTED]> said:leegold <mailto:[EMAIL PROTECTED]> on Friday, October 15, 2004 2:32 PM said:
> I do fulltext search on "work". And AFAIK the search will not find > "work". For that matter the seach will not find "ingm". How do I > implement in MYSQL/PHP a search that will have this action?
please share the current query you are trying to use and we can go from there.
Well, my current query is below, it searchs a text type field full of keywords with each record. The eventual user now said she wants a search "action" like I described above, kinda like a "find this string" that a text editor does. I would love to keep using Fulltext cause it has awesome features, but the wildcard can not be prepended *and* appended to a search term ie. *work*, no can do AFAIK. He's my current query in php,
$query = "SELECT page.* FROM `page` LEFT JOIN `keywords` USING (`page_id`) WHERE MATCH (`keywords`.`keyword_txt`) AGAINST ('$radio_keyword' IN BOOLEAN MODE)";
So I guess I could remove the fulltext index and reindex and do "...WHERE field LIKE '%string%';". But maybe there's a better way? I wish I could do *searchstring* in Fulltext even if the speed was slow as molasass it's the spec the user wants.
Lee G.
however, something simple is the following:
SELECT * FROM table WHERE field LIKE '%string%';
hth, chris.
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
