回答編集履歴
2
chousei
test
CHANGED
|
@@ -13,9 +13,9 @@
|
|
|
13
13
|
(4,'my ip is 192.168.1.99'),
|
|
14
14
|
(5,'slash / backslash \\');
|
|
15
15
|
|
|
16
|
-
select * from mytable where val regexp '\\\.';
|
|
17
|
-
select * from mytable where val regexp '\\\[';
|
|
18
|
-
select * from mytable where val regexp '\\
|
|
16
|
+
select * from mytable where val regexp '\\.';/*もしくは'\\\.'でもいける*/
|
|
17
|
+
select * from mytable where val regexp '\\[';/*もしくは'\\\['でもいける*/
|
|
18
|
+
select * from mytable where val regexp '\\{'; /*もしくは'{'や'\\\{'でもいける*/
|
|
19
19
|
select * from mytable where val regexp '\\\\';
|
|
20
20
|
```
|
|
21
|
-
|
|
21
|
+
一部過剰にエスケープしていたかもしれないので修正
|
1
ちょうせい
test
CHANGED
|
@@ -1,4 +1,21 @@
|
|
|
1
|
+
みなまで書く必要がありました？
|
|
2
|
+
|
|
1
3
|
```SQL
|
|
2
|
-
|
|
4
|
+
create table mytable (
|
|
5
|
+
id int primary key,
|
|
6
|
+
val varchar(50)
|
|
7
|
+
);
|
|
8
|
+
|
|
9
|
+
insert into mytable values
|
|
10
|
+
(1,'This line ends with a dot.'),
|
|
11
|
+
(2,'[text] kaku kakko'),
|
|
12
|
+
(3,'{text} nami kakko'),
|
|
13
|
+
(4,'my ip is 192.168.1.99'),
|
|
14
|
+
(5,'slash / backslash \\');
|
|
15
|
+
|
|
3
|
-
where val regexp '\\\.'
|
|
16
|
+
select * from mytable where val regexp '\\\.';
|
|
17
|
+
select * from mytable where val regexp '\\\[';
|
|
18
|
+
select * from mytable where val regexp '\\\{'; /*もしくは'{'でもいける*/
|
|
19
|
+
select * from mytable where val regexp '\\\\';
|
|
4
20
|
```
|
|
21
|
+
|