Spaces in Data Fields

Greetings,

   My search of the archives is still in progress but I thought I would
throw this out there.

I am using Perl 5.8.0  I just installed the DBI and DBD modules directly
from CPAN last week.  MySQL is version 4.0.14 running on two different
platforms Solaris 8 and Solaris 9.

   If I do a select statement from with-in the MySQL command interface I can
do a search on a field where the data contains one or more spaces
I.E  select * from mytable where myfield="this and that";

   However, if I try the same thing inside a Perl script I get zero results,
and not errors other then no record found.  It doesn't matter if I do this
inside a prepare(g{ }); or in a do("select * from"); statement. Even if I
escape the spaces it still fails to find the records that the command line
MySQL locates.   I can use Perl to put the data in the database I just can't
use Perl in this manner to locate the record.  I have had to resort to using
a select * from mytable and extracting the data line by line and parse the
field as if this was a flat ASCII file. 

   Anyone have an idea how I can get this to work other then putting "this"
in one field and "that in a different field?

   Thanks in advance

Regards,
Pete
----
Peter P. Benac, CCNA
Celtic Spirit Networking
Providing Network and Systems Project Management and Installation and Web
Hosting.
Phone: 919-618-2557
Web: http://www.emacolet.com
Need quick reliable Systems or Network Management advice visit
http://www.nmsusers.org

To have principles...
             First have courage.. With principles comes integrity!!!




-- 
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe:    http://lists.mysql.com/[email protected]