any way to perform a fulltext search on a string less than four characters (e.g. PHP?)

am 23.11.2005 13:01:15 von John McClumpha

Does anyone know of a way to perform a fulltext search (PHP/MYSQL) on
a string less than 4 characters in length?

e.g. if searching for 'PHP' ?

I thought about a boolean search adding * before/after the search
string -
*PHP*' - however that doesn't seem to work either...

TIA

--
John McClumpha
Darkness Reigns - http://www.incitegraphics.com.au/darkness/

Re: any way to perform a fulltext search on a string less than four characters (e.g. PHP?)

am 24.11.2005 11:05:03 von chotiwallah

not sure if that's what you're looking for:

SELECT * FROM some_table WHERE some_column LIKE '%PHP%'

Re: any way to perform a fulltext search on a string less than four characters (e.g. PHP?)

am 24.11.2005 11:05:03 von chotiwallah

not sure if that's what you're looking for:

SELECT * FROM some_table WHERE some_column LIKE '%PHP%'

Re: any way to perform a fulltext search on a string less than fourcharacters (e.g. PHP?)

am 24.11.2005 19:35:44 von Nick

John McClumpha wrote:
> Does anyone know of a way to perform a fulltext search (PHP/MYSQL) on
> a string less than 4 characters in length?
>
> e.g. if searching for 'PHP' ?

$sentence = 'A string that contains PHP, the name of this language';

if ( strpos($sentence, 'PHP') !== FALSE )
echo "Found PHP in the string";
?>

> I thought about a boolean search adding * before/after the search
> string -
> *PHP*' - however that doesn't seem to work either...
>
> TIA
>
> --
> John McClumpha
> Darkness Reigns - http://www.incitegraphics.com.au/darkness/

Re: any way to perform a fulltext search on a string less than fourcharacters (e.g. PHP?)

am 24.11.2005 19:35:44 von Nick