MySQL Forums
Forum List  »  Spanish

Re: Sumar todas las palabras repetidas
Posted by: David Gonzalez
Date: November 22, 2019 01:56PM

Se me ocurre que usen SUM

select SUM(pregunta1) + SUM(pregunta2) + SUM(pregunta3) AS Total FROM evaluacion WHERE pregunta1 LIKE 'muy bien' OR pregunta2 LIKE 'muy bien' OR pregunta3 LIKE 'muy bien'

En todo caso sino te funciona con OR puedes probar AND

Saludos,
David

Options: ReplyQuote


Subject
Views
Written By
Posted
760
November 17, 2019 11:44PM
Re: Sumar todas las palabras repetidas
292
November 22, 2019 01:56PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.