Use \ to escape.
mysql> insert into table1 values ('algo\,otra');
Query OK, 1 row affected (0.00 sec)
mysql> select * from table1;
+-----------+
| a |
+-----------+
| algo |
| algo,otra |
+-----------+
2 rows in set (0.00 sec)
On Sat, Mar 8, 2008 at 1:52 AM, J. Todd Slack
<[EMAIL PROTECTED]> wrote:
> Hi All,
>
> I have a client that wants to insert data into a VarChar field that contains
> commas. These are property addresses.
>
> Example:
> 2966 Moorpark Ave, San Jose, CA, 95128
>
> 1 Infinite Loop, Cupertino, CA, 955555
>
> How can I allow this?
>
> Thanks!
> -Jason
>
--
obed.org.mx
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
