full text search

[xbl12]

Hello;
Could anyone give me a idea how to do the full text search in the following case, please?

Example. Say I search for 'print', I would get results returned when words such as 'printers, printing, prints etc' are found.

 

[feherke]

Hi

[tt]like[/tt] ?

[b]select[/b] * [b]from[/b] thetable [b]where[/b] thefield [b]like[/b] [i]'print%'[/i];

Feherke.

http://rootshell.be/~feherke/