MySQL INSERT with pound sign (#) in one of the fields is failing, and escaping with '\' does not work.

I'm trying to issue a simple set of SQL instructions to create/populate a table in MySQL via phpMyAdmin.  One of the fields has a pound sign in it, and I don't know how to escape it. ("\" isn't working).

Here are the versions reported...

  phpMyAdmin 2.1.0
  MySQL 3.22.25

Here's my SQL...

# phpMyAdmin MySQL-Dump
# http://phpwizard.net/phpMyAdmin/
#
# Host: localhost Database : TESTDB
# --------------------------------------------------------

#
# Table structure for table 'testtable'
#

CREATE TABLE testtable (
   testID int(11) DEFAULT '0' NOT NULL auto_increment,
   testName varchar(40) NOT NULL,
   testAddr varchar(50) NOT NULL,
   testCity varchar(30) NOT NULL,
   testState varchar(10) NOT NULL,
   testZip varchar(10) NOT NULL,
   PRIMARY KEY (testID)
);

#
# Dumping data for table 'testtable'
#

INSERT INTO testtable VALUES ( '100', 'John Doe\'s House',  '123 Main St.', 'Anytown', 'AK', '99901');
INSERT INTO testtable VALUES ( '101', 'Art Stowe', 'RR #1', 'GRock', 'NJ', '07452');
INSERT INTO testtable VALUES ( '102', 'Jane Doe',  '456 Maple Ave.', 'Othertown', 'AK', '99901');


Upon submitting the above, MySQL/phpMyAdmin said: You have an error in your SQL syntax near '102', 'Jane Doe', '456 Maple Ave.', 'Othertown', 'AK', '99901');' at line 1

As I stated above, I discovered it was the pound sign (this makes sense, MySQL thinks I'm beginning a comment). So I tried escaping it with '\' but that did not work.  For kicks, I even tried '##'... but same failure.

So I removed the pound sign and resubmitted the SQL into phpMyAdmin and the table was successfully created with all three entries.  I then used phpMyAdmin to edit the Art Stowe address from "RR 1" back to "RR #1".  I then used phpMyAdmin's "View dump (schema) of table" function to dump the structure and data.  This way, I could see how it deals with the pound sign.  But here's what it dumped...


# phpMyAdmin MySQL-Dump
# http://phpwizard.net/phpMyAdmin/
#
# Host: localhost Database : TESTDB
# --------------------------------------------------------

#
# Table structure for table 'testtable'
#

CREATE TABLE testtable (
   testID int(11) DEFAULT '0' NOT NULL auto_increment,
   testName varchar(40) NOT NULL,
   testAddr varchar(50) NOT NULL,
   testCity varchar(30) NOT NULL,
   testState varchar(10) NOT NULL,
   testZip varchar(10) NOT NULL,
   PRIMARY KEY (testID)
);

#
# Dumping data for table 'testtable'
#

INSERT INTO testtable VALUES ( '100', 'John Doe\'s House', '123 Main St.', 'Anytown', 'AK', '99901');
INSERT INTO testtable VALUES ( '101', 'Art Stowe', 'RR #1', 'GRock', 'NJ', '07452');
INSERT INTO testtable VALUES ( '102', 'Jane Doe', '456 Maple Ave.', 'Othertown', 'AK', '99901');

From observation, you will see this is identical SQL code that I dealt with originally. It did not escape the pound sign.  This makes no sense to me.

Any tips on how to get MySQL/phpMyAdmin to accept pound signs in an INSERT command?  To repeat, preceding the '#' with a '\' did not work.

Thanks,

SV