Dreamweaver - MySQL Simple Query Not Working?

Author

MySQL Simple Query Not Working?

Bdog4

2006-02-28, 6:21 pm

I'm trying to do this query below using a the LIKE command but is not
working for me which I assume if the word Smith shows up in the persons last
name it will give me a result but it isn't. Also I'm using Dreamweaver for
this, both queries work when I run from Navicat but the first does not in
dreamweaver?

SELECT RecFirstName, RecLastName
FROM RecUsers
WHERE RecLastName LIKE '%Smith%'

Results = 0

But if I do this it works??
SELECT RecFirstName, RecLastName
FROM RecUsers
WHERE RecLastName LIKE 'Smith%'

Results 2 rows
Kim Smith
John Smith

Any ideas on why this isn't working?