|
|
Posted by shimmyshack on 06/28/07 17:08
On Jun 28, 4:52 pm, odysseyphotography <i...@odysseyphotography.net>
wrote:
> Sorry, I should have been clearer.
>
> The site I am working on has a keyword (FULLTEXT) search, where users
> can enter search terms to search the databse with.
>
> The default settings for MySQL mean that any words less than four
> character long in any given 'search term' will be ignored.
>
> My problem is that users on my client's website are likely to be using
> very short search terms (2 characters). These will be ignored unless I
> can find of a work around.
>
> The site is hosted on a commercial server, so I am unable to access
> the MySQL settings.
>
> Thanks,
>
> OP
its nasty cut you could have an IO filter, an array containing these
short words that will bepushed to the database
whereby any one of these special terms being stored in the database
gets _make_me_longer_
prepended to it, and any keyword term would therefore use this as
well, when the data is extracted from the db, the string is removed,
and the result set displayed.
If they are words do you have to search for them using a keyword
search, could you not use
' XX '
where that word including spaces is 4 characters? Anyway thats all I
got right now.
Navigation:
[Reply to this message]
|