PHP Search function - Individual keywords appearing in larger words

[bigbrennan]

Hi,

 

We have a PHP search function our site which searches various MySQL fields.

 

Our problem is this -

 

 

If you search for the word 'IT', the results shown will include any records with words such as 'with','british' because these contain the letters 'it'.

 

Is there a way we can tell the script to ignore keywords with letters around them, example:

 

Show anything with IT

Do not show anything with *IT*

* = wild card

 

Any help and assistance would be greatly appreciated.

 

Thanks

[Barand]

Are you searching column containing

 

a )  a single word

b )  several keywords (how separated?)

c )  sentences

d )  other

 

Are you searching using

 

i )  WHERE col LIKE 'x'

ii )  fulltext

iii)  other

[bigbrennan]

Thanks for the quick response.

 

The column's contain sentences. For example it would contain the work expereince section of your CV.

 

It searches using: fulltext and regex (regular expression).

[Barand]

I thought that you had to explicitly provide the "*" wildcard to make fulltext pull words containing the keyword