Re: [SQL] Newbie questions

> > > select * from animals where id='dogs' ignore case;
> >
> > look at operators in docs
> > ~~ - LIKE operator
> > ~* - match(regex), case insensitive operator
> > I have no idea which is better
> >     Rem
> > p.s. I could make some mistakes in this examples - check in amnual or docs
>
> The like and regexp do a match rather than an equality test.
> For an exact equality ignoring case, simply use
>
> SELECT *
> FROM animals
> WHERE lower( id ) = 'dogs';
[..]

So if they do match - I don't need to use with them some wild characters
(* or %)? And second question: Can I use % with = operator?
I know - simple question, but I feel now a little confused - manual
doesn't clear it either - I thought about it, but as long as all works
fine - I haven't needed this knowledge.
    TIA
    Rem
                                   *
                                   /\
-------------------------------------------------------------------*------------
Remigiusz Sokolowski      e-mail: rems@gdansk.sprint.pl        i/   o\i
-----------------------------------------------------------------o/&&\----------
                                 /  * \
    Wesolych Swiat Bozego Narodzenia i                   i/_o   _\i
    Szczesliwego Nowego Roku                o/   O\o
    Marry Christmas and Happy New Year!!!            / i    \
                                  i/____o___\i
                                   ||