search engine in 3.23.32

2001-11-13 Thread Craig Issod 

I'm running into the problem of word length shorter than 3 characters 
not being accepted in this version of FULLTEXT searches. Example at:
http://www.hearth.com/search/index.php (use fuzzy search at bottom)...

I can't recompile now, and also don't have the technical ability to 
create a complicated php work around, but here's what I'd like to do.

Set up some PHP to look at the submitted search string, and if any 
words in it (except for a small defined list in the PHP like "the, 
for") are exactly 3 characters, that search will go to a regular 
'LIKE" query instead of the default MATCH. I do know the if/then 
part...what I need help on is the logic of picking out 3 letter words.

I know this may be a bit off-topic, but any hints on doing so in PHP 
or javascript would be welcome.

-- 
------
Craig Issod HearthNet at http://www.hearth.com
[EMAIL PROTECTED]Everything your Hearth Desires
--

--  

-
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

Fulltext search variable

2001-11-12 Thread Craig Issod 

Using 3.23.32 on FreeBsd 3.2

Have gotten a sample fulltext search going, but cannot figure out how 
to shorten the word length to 2 o3 3, from the default 4.

Yes, I've read the docs, and tried the following:
Setting variable using mysqld on command line...it won't take it.

Looking at the variables - SHOW VARIABLES - it's not in there. 
ft_min_word_length does not seem to even exist. Can I simply create 
it somehow?

Looking for the config files mentioned in the docs...there is no 
directory called myisam on my directory tree.

looking for the .cnf files...I found:
/usr/local/mysql/share/mysql/my-huge.cnf
/usr/local/mysql/share/mysql/my-large.cnf
/usr/local/mysql/share/mysql/my-medium.cnf
/usr/local/mysql/share/mysql/my-small.cnf
/usr/local/share/mysql/my-example.cnf

Since I was not the original installer of mySQL on the system, I 
don't know which, if any, conf file is being used.

Can anyone offer me help pertaining to this particular distribution?

Thanks
-- 
------
Craig Issod HearthNet at http://www.hearth.com
[EMAIL PROTECTED]Everything your Hearth Desires
--

--  

-
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