Showing users with photos only

I'm not sure how to do this. I'm suing php with mysql, and in the photo field, it showing the info as /tmp/dsws etc. I've tried:

SELECT `id`,`username`,`photo` FROM `members` WHERE `photo` LIKE '%/tmp/' LIMIT 0, 30

But it shows no results. What am I doing wrong?

if the string you are trying to match is something like '/tmp/dsws' then your wildcard needs to be at the end. '/tmp/%' instead of at the beginning.

Rita

Thank you :D I never used wildcards before and phpMyAdmin put the % at the front, so that's where I thought it went :D It works now