Do you have a question? Post it now! No Registration Necessary. Now with pictures!
- Posted on
- Query that counts multiple values
February 9, 2007, 1:31 pm
rate this thread
I have a very basic question but I havent found answer to it anywhere.
I have a table that has following columns: date, answer1, answer2,
and entry: 2007-1-1, 'a', 'b', 'a', 'c'
What I want to do is count number of character "a":s as an answer.
Normally (if using COUNT, MATCH..AGAINST) mysql returns rows it finds.
I want to find out how many times this character "a" appears in a
What to do? Thanks for helping.
- » Americanas.com SALDO de TVs Com at 80% de Desconto (29798)
- — Newest thread in » MySQL Database Forum