Yes you can do it utilizing fulltext search in boolean mode...
SELECT * from list WHERE MATCH (cols) AGAINST ('pipp*' IN BOOLEAN MODE);
See: http://www.mysql.com/doc/F/u/Fulltext_Search.html
Gurhan
----- Original Message -----
From: "Patrick Sherrill" <[EMAIL PROTECTED]>
To: "mySQL List" <[EMAIL PROTECTED]>
Sent: Monday, July 22, 2002 10:35 AM
Subject: mysql FULLTEXT Searches
> Are partial word searches available with a FULLTEXT index.
>
> I.E. could the following select statement return any results given that
the
> word "Pippins" or "Pippin's" is indexed ?
>
>
> SELECT * from list WHERE MATCH (cols) AGAINST ('pipp')
>
> TIA,
>
> Pat...
> [EMAIL PROTECTED]
>
> MySql
>
>
> ---------------------------------------------------------------------
> 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
>
---------------------------------------------------------------------
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
