从MySQL数据库中删除具有特定域的URL？
要删除具有特定域的URL，请使用DELETE和LIKE子句。
让我们首先创建一个表-
mysql> create table DemoTable1361
-> (
-> URL text
-> ) ;使用插入命令在表中插入一些记录-
mysql> insert into DemoTable1361 values('Https://www.google.com//?id=1');
mysql> insert into DemoTable1361 values('Https://www.facebook.com//?id=2&name=John');
mysql> insert into DemoTable1361 values('Https://www.yahoo.com//?id=3');
mysql> insert into DemoTable1361 values('Https://www.google.com//?id=1');使用select语句显示表中的所有记录-
mysql> select * from DemoTable1361;
这将产生以下输出-
+-------------------------------------------+ | URL | +-------------------------------------------+ | Https://www.google.com//?id=1 | | Https://www.facebook.com//?id=2&name=John | | Https://www.yahoo.com//?id=3 | | Https://www.google.com//?id=1 | +-------------------------------------------+ 4 rows in set (0.00 sec)
这是从MySQL数据库中删除具有特定域的URL的查询-
mysql> delete from DemoTable1361 where URL LIKE '%Https://www.google.com%';
让我们再次检查表记录-
mysql> select * from DemoTable1361;
这将产生以下输出-
+-------------------------------------------+ | URL | +-------------------------------------------+ | Https://www.facebook.com//?id=2&name=John | | Https://www.yahoo.com//?id=3 | +-------------------------------------------+ 2 rows in set (0.00 sec)