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]
