No funciona fijate lo que me debuelve.. yo quiero que solo quede los que tienen firma y que no debuelva los null
Código:
mysql> select username, signature from user left join
-> usertextfield on user.userid = usertextfield.userid and signature <> ''
-> and signature IS NOT NULL limit 150,10;
+-----------------+----------------+
| username | signature |
+-----------------+----------------+
| CHiQuiTiTaCHuLa | NULL |
| salvioni | NULL |
| Waleska | Waleska |
| lachicabomba | la chica bomba |
| lachicabomba | la chica bomba |
| baby...queena | ¨¬w¥Ø¥ätM¥ám¡û |
| sheleine | sheleine |
| paolina_g | NULL |
| xxphattygirlxx | NULL |
| el natural | NULL |
+-----------------+----------------+