1 ------------------------------------------------------------------- select * FROM photos p, users u where p.uid = u.userid and concat(p.title,' ', u.uname,' ', u.ulastname) like '%$search%' 2 ------------------------------------------------------------------------ select * FROM photos p, users u where p.uid = u.userid and p.title like '$search%' and ( u.uname like '$search%' or u.ulastname like '$search%');