Re: how to insert ampersand in mysql table column with varchar data type

[Peter Brawley]

Eh?

drop table if exists t;
create table t(c varchar(8));
insert into t values( concat('&','abc') );
select * from t;
+------+
| c    |
+------+
| &abc |
+------+