[SQLize]
Home | About | FAQ | Links | Feedback

Enter MySQL script (temp tables/CRUD allowed, 5 sec / 5MB / 20 rows max):

create temporary table photos (id int, caption varchar(100));
1
2
3
4
5
6
7
8
9
 
create temporary table photos (id int, caption varchar(100));
 
insert photos values
    (1, 'Brad Pitt is wearing Angelina Jolie"s bikini');
 
update photos
   set caption = replace(caption, '"', '\'');
 
select * from photos;
| (permalink: 7FjtEyeLAh) Sample 1 | Sample 2

No results are displayed if 5 second timeout reached.

id
caption
id
caption
1Brad Pitt is wearing Angelina Jolie's bikini

(1 rows returned)