MySQL - 获得CVCV值的最佳方法？

I have a database table with lots and lots of words and strings. (Right now it has over 300K entries, but it grows.) What would be the best way to get only those values that fit the I have a database table with lots and lots of w