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