I'm doing a very simple search, however I'm running into an issue.
SELECT * FROM tbl_users WHERE usrType=0 AND usrFNAME LIKE '%[SEARCH_VAR]%' OR usrLName LIKE '%[SEARCH_VAR]%'
...Where SEARCH_VAR is some user entered keyword(s).
Problem is it not only returns matches where usrType=0, but also matches where usrType=1.
I'm sure I'm missing something basic here...
SELECT * FROM tbl_users WHERE usrType=0 AND usrFNAME LIKE '%[SEARCH_VAR]%' OR usrLName LIKE '%[SEARCH_VAR]%'
...Where SEARCH_VAR is some user entered keyword(s).
Problem is it not only returns matches where usrType=0, but also matches where usrType=1.
I'm sure I'm missing something basic here...
