【1】检索数据 1)检索单个列:select a_name from table_name; 2)检索多个列:select a_name,b_name from table_name;
3)检索所有列:select * from table_name;
attention)一般不推荐使用 select *,除非你确实需要表中的每个列,因为检索不需要的列通常会降低检索和应用程序的性能; 4)检索不同行: select distince column_name from table_name;
![MySQL检索数据(过滤+通配符+正则表达式) MySQL检索数据(过滤+通配符+正则表达式)](https://image.shishitao.com:8440/aHR0cHM6Ly93d3cuaXRkYWFuLmNvbS9nby9hSFIwY0RvdkwybHRaeTVpYkc5bkxtTnpaRzR1Ym1WMEx6SXdNVFl3TlRFMk1UVXpOakF6TVRFMQ%3D%3D.jpg?w=700&webp=1)
![MySQL检索数据(过滤+通配符+正则表达式) MySQL检索数据(过滤+通配符+正则表达式)](https://image.shishitao.com:8440/aHR0cHM6Ly93d3cuaXRkYWFuLmNvbS9nby9abWxzWlRvdkx5OUVPaTl3YjNOMFozSmhaSFZoZEdVdldXOTFaR0Z2VG05MFpTOTBaVzF3TFdacGJHVnpMM0JoWTI5emIyNUFNVFl6TG1OdmJTOWtObVl3TlRjMk4ySmtNV1EwTlRKaVltRTNNVFkzWXprMU1qTTJNbVk0WVM5ME1DNXdibWM9.jpg?w=700&webp=1)
![MySQL检索数据(过滤+通配符+正则表达式) MySQL检索数据(过滤+通配符+正则表达式)](https://image.shishitao.com:8440/aHR0cHM6Ly93d3cuaXRkYWFuLmNvbS9nby9hSFIwY0RvdkwybHRaeTVpYkc5bkxtTnpaRzR1Ym1WMEx6SXdNVFl3TlRFMk1UVXpOakU1T1RreA%3D%3D.jpg?w=700&webp=1)
![MySQL检索数据(过滤+通配符+正则表达式) MySQL检索数据(过滤+通配符+正则表达式)](https://image.shishitao.com:8440/aHR0cHM6Ly93d3cuaXRkYWFuLmNvbS9nby9abWxzWlRvdkx5OUVPaTl3YjNOMFozSmhaSFZoZEdVdldXOTFaR0Z2VG05MFpTOTBaVzF3TFdacGJHVnpMM0JoWTI5emIyNUFNVFl6TG1OdmJTOWhObUZtTVdFeU9UbGhNamcwT0dRM1ltUTROVEZoTUdJMU56aGtNRFpqTWk5ME1TNXdibWM9.jpg?w=700&webp=1)
![MySQL检索数据(过滤+通配符+正则表达式) MySQL检索数据(过滤+通配符+正则表达式)](https://image.shishitao.com:8440/aHR0cHM6Ly93d3cuaXRkYWFuLmNvbS9nby9hSFIwY0RvdkwybHRaeTVpYkc5bkxtTnpaRzR1Ym1WMEx6SXdNVFl3TlRFMk1UVXpOakk1T0RZMw%3D%3D.jpg?w=700&webp=1)
![MySQL检索数据(过滤+通配符+正则表达式) MySQL检索数据(过滤+通配符+正则表达式)](https://image.shishitao.com:8440/aHR0cHM6Ly93d3cuaXRkYWFuLmNvbS9nby9abWxzWlRvdkx5OUVPaTl3YjNOMFozSmhaSFZoZEdVdldXOTFaR0Z2VG05MFpTOTBaVzF3TFdacGJHVnpMM0JoWTI5emIyNUFNVFl6TG1OdmJTOHlZek5tTVRGbFptWXlNekkwTlRobU9XWTFPRGhoTUdWaVpqSTVNV0UxWWk5ME1pNXdibWM9.jpg?w=700&webp=1)
Attention)
A1)行0:检索出来的第一行是行0而不是行1,所以 limit 1,1 将检索出第二行而不是第一行; A2)MySQL5的limit语法:limit 3,4 表示 从行3开始的4行; A3)上面的limit 3,4 容易吧人搞糊涂,一种替代语法:limit 4 offset 3;从行3开始取4行;
![MySQL检索数据(过滤+通配符+正则表达式) MySQL检索数据(过滤+通配符+正则表达式)](https://image.shishitao.com:8440/aHR0cHM6Ly93d3cuaXRkYWFuLmNvbS9nby9abWxzWlRvdkx5OUVPaTl3YjNOMFozSmhaSFZoZEdVdldXOTFaR0Z2VG05MFpTOTBaVzF3TFdacGJHVnpMM0JoWTI5emIyNUFNVFl6TG1OdmJTODRObUZtTlRNMU1UUTFOR1kwWkdWbE9EWXlORGN6T1RnM01EVXhNR0ppTkM5ME15NXdibWM9.jpg?w=700&webp=1)
![MySQL检索数据(过滤+通配符+正则表达式) MySQL检索数据(过滤+通配符+正则表达式)](https://image.shishitao.com:8440/aHR0cHM6Ly93d3cuaXRkYWFuLmNvbS9nby9hSFIwY0RvdkwybHRaeTVpYkc5bkxtTnpaRzR1Ym1WMEx6SXdNVFl3TlRFMk1UVXpOalUzTkRRMQ%3D%3D.jpg?w=700&webp=1)
![MySQL检索数据(过滤+通配符+正则表达式) MySQL检索数据(过滤+通配符+正则表达式)](https://image.shishitao.com:8440/aHR0cHM6Ly93d3cuaXRkYWFuLmNvbS9nby9abWxzWlRvdkx5OUVPaTl3YjNOMFozSmhaSFZoZEdVdldXOTFaR0Z2VG05MFpTOTBaVzF3TFdacGJHVnpMM0JoWTI5emIyNUFNVFl6TG1OdmJTOHlZV05tWWpZMk0ySTFNek0wWVdFMVlqSTNZemxoTW1GbE5URTRPR0ppWmk5ME5DNXdibWM9.jpg?w=700&webp=1)
![MySQL检索数据(过滤+通配符+正则表达式) MySQL检索数据(过滤+通配符+正则表达式)](https://image.shishitao.com:8440/aHR0cHM6Ly93d3cuaXRkYWFuLmNvbS9nby9hSFIwY0RvdkwybHRaeTVpYkc5bkxtTnpaRzR1Ym1WMEx6SXdNVFl3TlRFMk1UVXpOekEyT1RFeg%3D%3D.jpg?w=700&webp=1)
![MySQL检索数据(过滤+通配符+正则表达式) MySQL检索数据(过滤+通配符+正则表达式)](https://image.shishitao.com:8440/aHR0cHM6Ly93d3cuaXRkYWFuLmNvbS9nby9abWxzWlRvdkx5OUVPaTl3YjNOMFozSmhaSFZoZEdVdldXOTFaR0Z2VG05MFpTOTBaVzF3TFdacGJHVnpMM0JoWTI5emIyNUFNVFl6TG1OdmJTOW1ZbUk0TVdSbU0yWXpZelUwTmpnMU9UTTJNV00wTlRBNFl6UTFORFkwWlM5ME5TNXdibWM9.jpg?w=700&webp=1)
A1)与desc相反的关键字时 asc(ascend,升高); A2)关键字 desc 只应用到其前面的列名;
![MySQL检索数据(过滤+通配符+正则表达式) MySQL检索数据(过滤+通配符+正则表达式)](https://image.shishitao.com:8440/aHR0cHM6Ly93d3cuaXRkYWFuLmNvbS9nby9abWxzWlRvdkx5OUVPaTl3YjNOMFozSmhaSFZoZEdVdldXOTFaR0Z2VG05MFpTOTBaVzF3TFdacGJHVnpMM0JoWTI5emIyNUFNVFl6TG1OdmJTOWtPREkyTkRNMk9XTmlOV1kwWVRReVlqY3lOekEyTmpFM1l6RTFOREpoTUM5ME5pNXdibWM9.jpg?w=700&webp=1)
【3】过滤数据 1)使用where子句:where的位置 在order by 之前; 2)where子句的操作符
![MySQL检索数据(过滤+通配符+正则表达式) MySQL检索数据(过滤+通配符+正则表达式)](https://image.shishitao.com:8440/aHR0cHM6Ly93d3cuaXRkYWFuLmNvbS9nby9hSFIwY0RvdkwybHRaeTVpYkc5bkxtTnpaRzR1Ym1WMEx6SXdNVFl3TlRFMk1UVXpOek0wTXpJeA%3D%3D.jpg?w=700&webp=1)
![MySQL检索数据(过滤+通配符+正则表达式) MySQL检索数据(过滤+通配符+正则表达式)](https://image.shishitao.com:8440/aHR0cHM6Ly93d3cuaXRkYWFuLmNvbS9nby9abWxzWlRvdkx5OUVPaTl3YjNOMFozSmhaSFZoZEdVdldXOTFaR0Z2VG05MFpTOTBaVzF3TFdacGJHVnpMM0JoWTI5emIyNUFNVFl6TG1OdmJTOWpZbUU0WmpjMU4yTmhZV0UwT0RobE9EWm1PR1JrWWpZNU1tSXlaR1V5WkM5ME55NXdibWM9.jpg?w=700&webp=1)
3)范围检查:between的测试用例
![MySQL检索数据(过滤+通配符+正则表达式) MySQL检索数据(过滤+通配符+正则表达式)](https://image.shishitao.com:8440/aHR0cHM6Ly93d3cuaXRkYWFuLmNvbS9nby9hSFIwY0RvdkwybHRaeTVpYkc5bkxtTnpaRzR1Ym1WMEx6SXdNVFl3TlRFMk1UVXpOelF4TkRRMg%3D%3D.jpg?w=700&webp=1)
![MySQL检索数据(过滤+通配符+正则表达式) MySQL检索数据(过滤+通配符+正则表达式)](https://image.shishitao.com:8440/aHR0cHM6Ly93d3cuaXRkYWFuLmNvbS9nby9abWxzWlRvdkx5OUVPaTl3YjNOMFozSmhaSFZoZEdVdldXOTFaR0Z2VG05MFpTOTBaVzF3TFdacGJHVnpMM0JoWTI5emIyNUFNVFl6TG1OdmJTODJZbUUyWWpoa09EWmlPRFkwTkRJeFlUUmxaRGs0T1dNek5qZ3pPVE0xWmk5ME9DNXdibWM9.jpg?w=700&webp=1)
![MySQL检索数据(过滤+通配符+正则表达式) MySQL检索数据(过滤+通配符+正则表达式)](https://image.shishitao.com:8440/aHR0cHM6Ly93d3cuaXRkYWFuLmNvbS9nby9abWxzWlRvdkx5OUVPaTl3YjNOMFozSmhaSFZoZEdVdldXOTFaR0Z2VG05MFpTOTBaVzF3TFdacGJHVnpMM0JoWTI5emIyNUFNVFl6TG1OdmJTOWlOVFl5WlROaFlqVXpPV1kwWVRBMVlXVTRNRE0yTkRWa01UZzBabUUzWVM5ME9TNXdibWM9.jpg?w=700&webp=1)
![MySQL检索数据(过滤+通配符+正则表达式) MySQL检索数据(过滤+通配符+正则表达式)](https://image.shishitao.com:8440/aHR0cHM6Ly93d3cuaXRkYWFuLmNvbS9nby9hSFIwY0RvdkwybHRaeTVpYkc5bkxtTnpaRzR1Ym1WMEx6SXdNVFl3TlRFMk1UVXpOelU1TXpJeQ%3D%3D.jpg?w=700&webp=1)
【4】过滤数据补充 1)组合where子句
1.1)and 操作符:2)in 操作符:in 操作符用来指定条件范围,范围中的每个条件都可以进行匹配;其功能和or 操作符相同;
![]()
1.2)or 操作符:
![]()
1.3)计算次序:请注意 and 和 or 操作符的优先级,and的优先级高于or,必要时使用括号;
![MySQL检索数据(过滤+通配符+正则表达式) MySQL检索数据(过滤+通配符+正则表达式)](https://image.shishitao.com:8440/aHR0cHM6Ly93d3cuaXRkYWFuLmNvbS9nby9hSFIwY0RvdkwybHRaeTVpYkc5bkxtTnpaRzR1Ym1WMEx6SXdNVFl3TlRFMk1UVXpPRE16TmpneQ%3D%3D.jpg?w=700&webp=1)
![MySQL检索数据(过滤+通配符+正则表达式) MySQL检索数据(过滤+通配符+正则表达式)](https://image.shishitao.com:8440/aHR0cHM6Ly93d3cuaXRkYWFuLmNvbS9nby9abWxzWlRvdkx5OUVPaTl3YjNOMFozSmhaSFZoZEdVdldXOTFaR0Z2VG05MFpTOTBaVzF3TFdacGJHVnpMM0JoWTI5emIyNUFNVFl6TG1OdmJTOHhOemswT1dKa09UUm1aV0UwTVdFd1lqazBOVGN4TVRReVpqVXdNMk00Tmk5ME1USXVjRzVu.jpg?w=700&webp=1)
![MySQL检索数据(过滤+通配符+正则表达式) MySQL检索数据(过滤+通配符+正则表达式)](https://image.shishitao.com:8440/aHR0cHM6Ly93d3cuaXRkYWFuLmNvbS9nby9abWxzWlRvdkx5OUVPaTl3YjNOMFozSmhaSFZoZEdVdldXOTFaR0Z2VG05MFpTOTBaVzF3TFdacGJHVnpMM0JoWTI5emIyNUFNVFl6TG1OdmJTOHpNalEyT1RCaFlqQXpZalUwTXpGbU9EbG1aVGhqTUdVME56TTNaR000TXk5ME1UTXVjRzVu.jpg?w=700&webp=1)
![MySQL检索数据(过滤+通配符+正则表达式) MySQL检索数据(过滤+通配符+正则表达式)](https://image.shishitao.com:8440/aHR0cHM6Ly93d3cuaXRkYWFuLmNvbS9nby9hSFIwY0RvdkwybHRaeTVpYkc5bkxtTnpaRzR1Ym1WMEx6SXdNVFl3TlRFMk1UVXpPRFF6TURReA%3D%3D.jpg?w=700&webp=1)
【5】用通配符进行过滤 0)intro to 通配符
0.1)通配符:用来匹配值的一部分的特殊字符; 0.2)搜索模式:由字面值,通配符或两者组合构成的搜索条件; 0.3)必须使用like操作符:为在搜索子句中使用通配符,必须使用like 操作符。like指示MySQL,后跟的搜索模式利用通配符匹配而不是直接相等匹配进行比较;1)通配符介绍
1.1)百分号(%)通配符:%表示任何字符出现任意次数;
![MySQL检索数据(过滤+通配符+正则表达式) MySQL检索数据(过滤+通配符+正则表达式)](https://image.shishitao.com:8440/aHR0cHM6Ly93d3cuaXRkYWFuLmNvbS9nby9abWxzWlRvdkx5OUVPaTl3YjNOMFozSmhaSFZoZEdVdldXOTFaR0Z2VG05MFpTOTBaVzF3TFdacGJHVnpMM0JoWTI5emIyNUFNVFl6TG1OdmJTODFNamMwTWpjeU16RmtabVUwTVdJeVlqSXpNRFJqTTJSaVlUSTBPVEE1TVM5ME1UUXVjRzVu.jpg?w=700&webp=1)
![MySQL检索数据(过滤+通配符+正则表达式) MySQL检索数据(过滤+通配符+正则表达式)](https://image.shishitao.com:8440/aHR0cHM6Ly93d3cuaXRkYWFuLmNvbS9nby9abWxzWlRvdkx5OUVPaTl3YjNOMFozSmhaSFZoZEdVdldXOTFaR0Z2VG05MFpTOTBaVzF3TFdacGJHVnpMM0JoWTI5emIyNUFNVFl6TG1OdmJTOWlZVFUzTjJFeU5tVmxaV0UwTmpZM09EWTNOamN5WXpJMk1HWmxNR1poWkM5ME1UVXVjRzVu.jpg?w=700&webp=1)
![MySQL检索数据(过滤+通配符+正则表达式) MySQL检索数据(过滤+通配符+正则表达式)](https://image.shishitao.com:8440/aHR0cHM6Ly93d3cuaXRkYWFuLmNvbS9nby9hSFIwY0RvdkwybHRaeTVpYkc5bkxtTnpaRzR1Ym1WMEx6SXdNVFl3TlRFMk1UVXpPVEUwTmpBMA%3D%3D.jpg?w=700&webp=1)
![MySQL检索数据(过滤+通配符+正则表达式) MySQL检索数据(过滤+通配符+正则表达式)](https://image.shishitao.com:8440/aHR0cHM6Ly93d3cuaXRkYWFuLmNvbS9nby9abWxzWlRvdkx5OUVPaTl3YjNOMFozSmhaSFZoZEdVdldXOTFaR0Z2VG05MFpTOTBaVzF3TFdacGJHVnpMM0JoWTI5emIyNUFNVFl6TG1OdmJTOHhOV013T1RZMlpESTJNVE0wTnpsallUTTFNems1TjJZMVkyVTNOR1ZpT0M5ME1UWXVjRzVu.jpg?w=700&webp=1)
s1)不要过度使用通配符; s2)在确实需要使用通配符时,除非绝对有必要,否则不要把它们用在搜索模式的开始处。把通配符置于搜索模式的开始处,搜索起来是最慢的 ;
【6】用正则表达式进行搜索 1)intro to 正则表达式:正则表达式的作用是匹配文本,将一个模式(正则表达式)与一个文本串进行比较; 2)基本字符匹配:
![MySQL检索数据(过滤+通配符+正则表达式) MySQL检索数据(过滤+通配符+正则表达式)](https://image.shishitao.com:8440/aHR0cHM6Ly93d3cuaXRkYWFuLmNvbS9nby9hSFIwY0RvdkwybHRaeTVpYkc5bkxtTnpaRzR1Ym1WMEx6SXdNVFl3TlRFMk1UVXpPVE0yTnpreQ%3D%3D.jpg?w=700&webp=1)
![MySQL检索数据(过滤+通配符+正则表达式) MySQL检索数据(过滤+通配符+正则表达式)](https://image.shishitao.com:8440/aHR0cHM6Ly93d3cuaXRkYWFuLmNvbS9nby9abWxzWlRvdkx5OUVPaTl3YjNOMFozSmhaSFZoZEdVdldXOTFaR0Z2VG05MFpTOTBaVzF3TFdacGJHVnpMM0JoWTI5emIyNUFNVFl6TG1OdmJTOWlNbVJrTnpkaU16aGpORE0wWlRobE9UYzVPVGt6TW1RME56ZzRPVEF5WVM5ME1UY3VjRzVu.jpg?w=700&webp=1)
![MySQL检索数据(过滤+通配符+正则表达式) MySQL检索数据(过滤+通配符+正则表达式)](https://image.shishitao.com:8440/aHR0cHM6Ly93d3cuaXRkYWFuLmNvbS9nby9hSFIwY0RvdkwybHRaeTVpYkc5bkxtTnpaRzR1Ym1WMEx6SXdNVFl3TlRFMk1UVXpPVFV6TlRnNQ%3D%3D.jpg?w=700&webp=1)
![MySQL检索数据(过滤+通配符+正则表达式) MySQL检索数据(过滤+通配符+正则表达式)](https://image.shishitao.com:8440/aHR0cHM6Ly93d3cuaXRkYWFuLmNvbS9nby9abWxzWlRvdkx5OUVPaTl3YjNOMFozSmhaSFZoZEdVdldXOTFaR0Z2VG05MFpTOTBaVzF3TFdacGJHVnpMM0JoWTI5emIyNUFNVFl6TG1OdmJTODJaVFExTkRFek1XRmpaVGswTXpFeE9ERTBPRGMzTWpBM01HRm1NakZqWWk5ME1UZ3VjRzVu.jpg?w=700&webp=1)
![MySQL检索数据(过滤+通配符+正则表达式) MySQL检索数据(过滤+通配符+正则表达式)](https://image.shishitao.com:8440/aHR0cHM6Ly93d3cuaXRkYWFuLmNvbS9nby9hSFIwY0RvdkwybHRaeTVpYkc5bkxtTnpaRzR1Ym1WMEx6SXdNVFl3TlRFMk1UVTBNREUxTXpneg%3D%3D.jpg?w=700&webp=1)
![MySQL检索数据(过滤+通配符+正则表达式) MySQL检索数据(过滤+通配符+正则表达式)](https://image.shishitao.com:8440/aHR0cHM6Ly93d3cuaXRkYWFuLmNvbS9nby9abWxzWlRvdkx5OUVPaTl3YjNOMFozSmhaSFZoZEdVdldXOTFaR0Z2VG05MFpTOTBaVzF3TFdacGJHVnpMM0JoWTI5emIyNUFNVFl6TG1OdmJTODNNRGMyTmpneU5qazVNVGMwWWpKaE9UY3hOVGM0TkRZME9ERXdaV05pTkM5ME1Ua3VjRzVu.jpg?w=700&webp=1)
![MySQL检索数据(过滤+通配符+正则表达式) MySQL检索数据(过滤+通配符+正则表达式)](https://image.shishitao.com:8440/aHR0cHM6Ly93d3cuaXRkYWFuLmNvbS9nby9hSFIwY0RvdkwybHRaeTVpYkc5bkxtTnpaRzR1Ym1WMEx6SXdNVFl3TlRFMk1UVTBNREkyTURVMA%3D%3D.jpg?w=700&webp=1)
![MySQL检索数据(过滤+通配符+正则表达式) MySQL检索数据(过滤+通配符+正则表达式)](https://image.shishitao.com:8440/aHR0cHM6Ly93d3cuaXRkYWFuLmNvbS9nby9abWxzWlRvdkx5OUVPaTl3YjNOMFozSmhaSFZoZEdVdldXOTFaR0Z2VG05MFpTOTBaVzF3TFdacGJHVnpMM0JoWTI5emIyNUFNVFl6TG1OdmJTODNabU0yTVRoa1lqVXdaVGMwWVdWbU9URXpaV1pqT0Rsa1pXSmlZbVpsTUM5ME1qQXVjRzVu.jpg?w=700&webp=1)
A1)正则表达式[12]000 是 [1|2]000的缩写; A2)字符集合也可以被否定:即,他们将匹配除指定字符外的任何东西。为否定一个字符集,在集合的开始处放置一个 ‘^’即可。
![MySQL检索数据(过滤+通配符+正则表达式) MySQL检索数据(过滤+通配符+正则表达式)](https://image.shishitao.com:8440/aHR0cHM6Ly93d3cuaXRkYWFuLmNvbS9nby9abWxzWlRvdkx5OUVPaTl3YjNOMFozSmhaSFZoZEdVdldXOTFaR0Z2VG05MFpTOTBaVzF3TFdacGJHVnpMM0JoWTI5emIyNUFNVFl6TG1OdmJTOWxOekUwTkRjd01qaGpOREUwTjJabFltSTRNelprTjJaak1UbG1NelEyWWk5ME1qRXVjRzVu.jpg?w=700&webp=1)
6.1)匹配数字0到9:[0-9]; 6.2)匹配字母a到z:[a-z];
![MySQL检索数据(过滤+通配符+正则表达式) MySQL检索数据(过滤+通配符+正则表达式)](https://image.shishitao.com:8440/aHR0cHM6Ly93d3cuaXRkYWFuLmNvbS9nby9abWxzWlRvdkx5OUVPaTl3YjNOMFozSmhaSFZoZEdVdldXOTFaR0Z2VG05MFpTOTBaVzF3TFdacGJHVnpMM0JoWTI5emIyNUFNVFl6TG1OdmJTODJPRGczWTJJMU5ETmpORFEwTnprMk9ETmhPREF3TXpZM01EUTNNamd5T0M5ME1qSXVjRzVu.jpg?w=700&webp=1)
problem)如果我们要匹配点(.)这个字符,应该怎么写正则表达式呢? solution)通过写 '\\.' 进行匹配;(这是所谓的转义字符)
![MySQL检索数据(过滤+通配符+正则表达式) MySQL检索数据(过滤+通配符+正则表达式)](https://image.shishitao.com:8440/aHR0cHM6Ly93d3cuaXRkYWFuLmNvbS9nby9abWxzWlRvdkx5OUVPaTl3YjNOMFozSmhaSFZoZEdVdldXOTFaR0Z2VG05MFpTOTBaVzF3TFdacGJHVnpMM0JoWTI5emIyNUFNVFl6TG1OdmJTODNOemd5T1RNeFpEY3dPRGMwWmpNME9EUTFZbUV4TldKaVpUWXpaVGc1TXk5ME1qTXVjRzVu.jpg?w=700&webp=1)
![MySQL检索数据(过滤+通配符+正则表达式) MySQL检索数据(过滤+通配符+正则表达式)](https://image.shishitao.com:8440/aHR0cHM6Ly93d3cuaXRkYWFuLmNvbS9nby9hSFIwY0RvdkwybHRaeTVpYkc5bkxtTnpaRzR1Ym1WMEx6SXdNVFl3TlRFMk1UVTBNVEl4T0RjeQ%3D%3D.jpg?w=700&webp=1)
![MySQL检索数据(过滤+通配符+正则表达式) MySQL检索数据(过滤+通配符+正则表达式)](https://image.shishitao.com:8440/aHR0cHM6Ly93d3cuaXRkYWFuLmNvbS9nby9abWxzWlRvdkx5OUVPaTl3YjNOMFozSmhaSFZoZEdVdldXOTFaR0Z2VG05MFpTOTBaVzF3TFdacGJHVnpMM0JoWTI5emIyNUFNVFl6TG1OdmJTODFZakJoWXpreU5ETTROVEEwTlRReU9UY3lPRE0zT1dZMU5UQTJZakV3TXk5ME1qUXVjRzVu.jpg?w=700&webp=1)
![MySQL检索数据(过滤+通配符+正则表达式) MySQL检索数据(过滤+通配符+正则表达式)](https://image.shishitao.com:8440/aHR0cHM6Ly93d3cuaXRkYWFuLmNvbS9nby9hSFIwY0RvdkwybHRaeTVpYkc5bkxtTnpaRzR1Ym1WMEx6SXdNVFl3TlRFMk1UVTBNVFEzT0RJMg%3D%3D.jpg?w=700&webp=1)
![MySQL检索数据(过滤+通配符+正则表达式) MySQL检索数据(过滤+通配符+正则表达式)](https://image.shishitao.com:8440/aHR0cHM6Ly93d3cuaXRkYWFuLmNvbS9nby9hSFIwY0RvdkwybHRaeTVpYkc5bkxtTnpaRzR1Ym1WMEx6SXdNVFl3TlRFMk1UVTBNVFU1T1RrNA%3D%3D.jpg?w=700&webp=1)
![MySQL检索数据(过滤+通配符+正则表达式) MySQL检索数据(过滤+通配符+正则表达式)](https://image.shishitao.com:8440/aHR0cHM6Ly93d3cuaXRkYWFuLmNvbS9nby9abWxzWlRvdkx5OUVPaTl3YjNOMFozSmhaSFZoZEdVdldXOTFaR0Z2VG05MFpTOTBaVzF3TFdacGJHVnpMM0JoWTI5emIyNUFNVFl6TG1OdmJTODVaRFl3WVdRMU1XUTFNek0wTUdNeFltSXhNVGMzWW1NNU1XUm1aVFl3WlM5ME1qVXVjRzVu.jpg?w=700&webp=1)
![MySQL检索数据(过滤+通配符+正则表达式) MySQL检索数据(过滤+通配符+正则表达式)](https://image.shishitao.com:8440/aHR0cHM6Ly93d3cuaXRkYWFuLmNvbS9nby9abWxzWlRvdkx5OUVPaTl3YjNOMFozSmhaSFZoZEdVdldXOTFaR0Z2VG05MFpTOTBaVzF3TFdacGJHVnpMM0JoWTI5emIyNUFNVFl6TG1OdmJTOWhNbVkxTVdFNVpXVmlOREEwT1Raa09UTTBOakJtTm1ZeE5tRm1OVGMyTVM5ME1qWXVjRzVu.jpg?w=700&webp=1)
10.1)为匹配特定位置的文本,需要定位符,如下所示:
![]()
10.2)匹配以数字或点(.)为开头的行
![MySQL检索数据(过滤+通配符+正则表达式) MySQL检索数据(过滤+通配符+正则表达式)](https://image.shishitao.com:8440/aHR0cHM6Ly93d3cuaXRkYWFuLmNvbS9nby9abWxzWlRvdkx5OUVPaTl3YjNOMFozSmhaSFZoZEdVdldXOTFaR0Z2VG05MFpTOTBaVzF3TFdacGJHVnpMM0JoWTI5emIyNUFNVFl6TG1OdmJTOHdNbUV6WlRFM1pXTmpZamMwWW1ZM09EZzBOemc1T1dGbVlqRTNPV1JqTnk5ME1qZ3VjRzVu.jpg?w=700&webp=1)
![MySQL检索数据(过滤+通配符+正则表达式) MySQL检索数据(过滤+通配符+正则表达式)](https://image.shishitao.com:8440/aHR0cHM6Ly93d3cuaXRkYWFuLmNvbS9nby9abWxzWlRvdkx5OUVPaTl3YjNOMFozSmhaSFZoZEdVdldXOTFaR0Z2VG05MFpTOTBaVzF3TFdacGJHVnpMM0JoWTI5emIyNUFNVFl6TG1OdmJTODBNelptWmpNM05tTTVNalEwWVRFeE9HUTJPREE0TXpka09UTm1NalZqWXk5ME1qa3VjRzVu.jpg?w=700&webp=1)
A1)‘^’ 字符的双重作用:在集合中(用[]定义 ),用它来否定该集合;否则(在[]前面),用来指定串的开始处; A2)regexp 和 like 的区别:like 匹配整个串而 regexp 匹配子串; A3)利用定位符,通过^ 开始每个表达式,$ 结束每个表达式;