Perhaps, add the DISTINCT modifier: SELECT distinct * FROM tutoriais,scripts WHERE tutoriais.nome LIKE '%mysql%' OR tutoriais.descricao LIKE '%mysql%' AND scripts.nome LIKE '%mysql'
-----Original Message----- From: Davis Zanetti Cabral [mailto:[EMAIL PROTECTED]] Sent: Wednesday, October 31, 2001 2:39 PM To: [EMAIL PROTECTED] Subject: Problems with search I have problems with searches where I try search in 2 or more tables with a query only. But the data came more that one time. I dont speak english very well... if somebody understand portuguese, please reply for me... sql => SELECT * FROM tutoriais,scripts WHERE tutoriais.nome LIKE '%mysql%' OR tutoriais.descricao LIKE '%mysql%' AND scripts.nome LIKE '%mysql' whats prob here? tanks... O meu problema eh pesquisas em 2 tabelas ao mesmo tempo... os dados se repetem... SELECT * FROM tutoriais,scripts WHERE tutoriais.nome LIKE '%mysql%' OR tutoriais.descricao LIKE '%mysql%' AND scripts.nome LIKE '%mysql' qual o problema nisso? obrigado Davis [EMAIL PROTECTED] --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
