network profile
| bio | website | jpwphoto.com |
|---|---|---|
| location | Tacoma, WA | |
| age | 44 | |
| visits | member for | 1 year, 11 months |
| seen | Jul 29 '11 at 3:49 | |
| stats | profile views | 1 |
|
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 |
