SQL is definitely not my specialty but you can use regular expressions within your select statement… is this something you want to pull on the fly each time though? It seems like as your data set grows it might become prohibitive… especially if you’re getting dugg each week ;) So I’d probably pull your strings and process them outside of SQL using whatever language you love and regular expressions (a search for borders should make this fairly easy, although I’m sure there’s outliers I’m not thinking of right now). I’d create a table for keywords, with an id, the term, and a count. Then just increment that count whenever that term is found, or if it’s not then create it in the table. This way you have your terms and counts somewhere as well and don’t have to generate them each and every time you need to pull one. When you add text to your primary table run a function to parse it up and drop information into your count table as well. It could get more complicated if you need to keep track of where the terms came from, but it doesn’t sound like that’s the case. Now you’ve got me wondering if I can write one SQL statement for it though, let me take a look.