force lower case or use the non case-senstitive search e.g.

lower(column) LIKE lower('%$suchbegriffe[$i]%')

or

column ~* '$suchbegriffe[$i]'
(no need for wildcards when using ~* it assumes %value%)



"Sebastian --[ www.flashhilfe.de ]--" <[EMAIL PROTECTED]> wrote in
message 95n58g$5fa$[EMAIL PROTECTED]">news:95n58g$5fa$[EMAIL PROTECTED]...
> Hi
>
> I hope someone can help me....
>
> My problem:
>
> I have make a search machine whit:
>
> LIKE '%$suchbegriffe[$i]%'
>
> but when I search Test - the search machine shows only entries
> whit Test. But not test or tESt.
>
> (sorry for my bad english)
>
> Regards, Sebastian
>
>


Reply via email to