RE: Fulltext Search help

[Santino]

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]

RE: Fulltext Search help

[leegold]

On Fri, 15 Oct 2004 20:05:57 -0400, leegold [EMAIL PROTECTED]
said:
 
 On Fri, 15 Oct 2004 15:00:10 -0700, Chris W. Parker
... 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.

Of course *searchstring* would invalidate the indexing.

Thanks.
Lee G.

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Fulltext Search help

[leegold]

I'm running into a limitation in the fulltext search though I think by
defination a fulltext search will not -  or even should not do this,
but I'd like to implement this this functionality somehow, 

given in a text doc. the string:  Yesterday I was superduperworkingman
at times.

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? 

Thanks,
Lee G.
Wash DC



-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: Fulltext Search help

[Chris W. Parker]

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.

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]

FULLTEXT Search Help!

[luc2]

Hello, I have FULLTEXT Indexes on 2 columns, Entry and EntryCountry. ( See
Below )

mysql show index from entries\g
+-++-+--+---+---
+-+--++--+
| Table   | Non_unique | Key_name| Seq_in_index | Column_name   |
Collation | Cardinality | Sub_part | Packed | Comment  |
+-++-+--+---+---
+-+--++--+
| entries |  1 | entries_idx |1 | Entry   | A
|NULL | NULL | NULL   |  |
| entries |  1 | entries_idx |2 | EntryCountry  | A
|NULL | NULL | NULL   |  |
| entries |  1 | Entry   |1 | Entry | A
|NULL |1 | NULL   | FULLTEXT |
| entries |  1 | Entry   |2 | EntryCountry  | A
|NULL | NULL | NULL   | FULLTEXT |
+-++-+--+---+---
+-+--++--+
8 rows in set (0.02 sec)

... but when I run a search I get:

mysql SELECT ID, MATCH ( Entry ) AGAINST ( 'peace corps' ) AS Score FROM
entries WHERE MATCH ( Entry ) AGAINST ( 'peace corps' ) 0 AND UID != 'demo'
HAVING Score 0 ORDER BY Score DESC\g

ERROR 1191: Can't find FULLTEXT index matching the column list


Why!?!?!?!

Help!
Luc


-
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