113 reputation
3
bio website jpwphoto.com
location Tacoma, WA
age 45
visits member for 3 years, 5 months
seen Jul 29 '11 at 3:49

Jul
8
awarded  Scholar
Jul
8
awarded  Supporter
Jul
8
accepted Query table A for any rows that are like any search term in table B
Jul
8
comment Query table A for any rows that are like any search term in table B
Sweet! Thanks! One thing I read is that full text search (which was what I was considering using initially) is intended more for large blocks of text rather than narrow columns. Regardless, your solution works great and will be fine for now. Will do more research as to whether or not I should use full text. I was trying to figure out how to do this with a subquery. Your solution is nice and simple (now that I've seen it!).
Jul
8
awarded  Student
Jul
8
asked Query table A for any rows that are like any search term in table B