开发者

Finding fields containing specific characters and quantities

开发者 https://www.devze.com 2023-04-10 19:51 出处:网络
I have a homework assignment where I have to find all the fields in a table containing 2 a\'s in them. I have been searching for hours. I am convinced I have to use wildcards but I continue to get fie

I have a homework assignment where I have to find all the fields in a table containing 2 a's in them. I have been searching for hours. I am convinced I have to use wildcards but I continue to get fields containing more than 2 fie开发者_JAVA百科lds which is no acceptable. Please Help!!!


You can use RLIKE:

WHERE my_field RLIKE "a{2}"
0

精彩评论

暂无评论...
验证码 换一张
取 消