Try this:

SELECT U_Username from w3t_Users where U_Location LIKE '%WA%'

Note how instead of = we use LIKE. Also the addition of % which is a wildcard. This should match both WA and Seattle, WA in that field. <img src="https://www.ubbcentral.com/boards/images/graemlins/smile.gif" alt="" />


Joshua Pettit
Web Developer
www.ThreadsDev.net | www.JoshuaPettit.com