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}"
 
         
                                         
                                         
                                         
                                        ![Interactive visualization of a graph in python [closed]](https://www.devze.com/res/2023/04-10/09/92d32fe8c0d22fb96bd6f6e8b7d1f457.gif) 
                                         
                                         
                                         
                                         加载中,请稍侯......
 加载中,请稍侯......
      
精彩评论