On Mon, 5 Feb 2001, Sebastian --[ www.flashhilfe.de ]-- wrote:
> 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.
LIKE is case-sensitive. You should convert your column to uppercase:
WHERE UPPER(field) LIKE ...
or use case-insensitive regular expression:
WHERE field ~* '<regexp>'
-- Brett
http://www.chapelperilous.net/~bmccoy/
---------------------------------------------------------------------------
The Angels want to wear my red shoes.
-- E. Costello
