List:General Discussion« Previous MessageNext Message »
From:Vivek Khera Date:April 29 1999 11:36am
Subject:Re: Perl DBI, for archiving
View as plain text  
>>>>> "CK" == Charles Kirby <kirbych@stripped> writes:

CK> Thanks, I'm still trying (and failing)...
CK> maybe it has something to do with the fact that "sid" is an integer, and
CK> that I can't get wildcards to work.
CK> For instance, this works from the command line:

mysql> select sid from slips;
CK>        this gets all the "sid"s, but if I try to do:

mysql> select sid from slips where sid=?;
CK>                           or "" where sid='?';, sid=%; etc etc, I always
CK> get "Empty set (0.00 sec)"

CK> Is there a way of specifying the wildcard for integer fields?

Wildcard substitution is a DBI thing, not a mysql command line thing.

try "select sid from slips where sid=3;" in mysql command prompt.


								v.

-- 
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Vivek Khera, Ph.D.                Khera Communications, Inc.
Internet: khera@stripped       Rockville, MD       +1-301-545-6996
PGP & MIME spoken here            http://www.kciLink.com/home/khera/
Thread
Perl DBI, for archivingCharles Kirby29 Apr
  • Re: Perl DBI, for archivingVivek Khera29 Apr
    • Re: Perl DBI, for archivingCharles Kirby29 Apr
      • Re: Perl DBI, for archivingPaul DuBois29 Apr
      • Re: Perl DBI, for archivingVivek Khera29 Apr
        • Re: Perl DBI, for archivingCharles Kirby29 Apr
          • Re: Perl DBI, for archivingPaul DuBois29 Apr
            • Re: Perl DBI, for archivingCharles Kirby29 Apr