Modify search database query to include "location" user field

[mvigod]

Does anyone familiar w/mysql database queries know how I would modify the search query to return results which also include the user location field?

so if they type "black hats texas" it will search the forums for "black hats" and then match that up with people who have their location set to texas that posted in that thread. I'm sure it's a database query modification but not sure how to define it.

Thanks to anyone who may be able to help on this query.

Best Regards,

Marc