SELECT concat(p.title," ", u.uname," ", u.ulastname) as alltext
FROM photos p, users u
where p.uid = u.userid
and alltext like "%a%"