multiple columns

clownbarf

How can I do a query on the table below that will return me. say return me "Where are the phone?" 5 times , instead of the number of rows they are on?

can't seem to do a query on .. where column, column2, column2 = ' where are the phones'

thanks,
Scott

jweissig

hi,

Can you please give me a layout of your database and the tables. Also can you please explain what you have tried up to this point.

thanks,
- justin

clownbarf

it's pretty much like the picture.
I want where are the phones 5 times and not 3 or 2.

I've tried..
select where question = 'where are the phones' UNION select where question2 = 'where are the phones... and so on
doesn't work.

I would have thought I can do sometime the would just tell how many times something shows up in any column.

thanks

jweissig

hey,

can you please describe how the tables are designed. I have no idea what you are talking about and i will only know if you give me a detailed explanation. Where are you getting this image from and what's it for?

Thanks,
- Justin

clownbarf

this table will take selections from three drop down boxes and place the questions in the one row as you see along with what category and a timestamp.

this whole thing is a tallysheet. to keep track of how manytimes someone asks a particular question during the day.
yes they will not ask where the phones are three times but in other categories they may..
it's very hard to explain..

I just need to figure out a total where a question was entered on a table bases and not per row... cause you see where are the phones (for testing only) is three times on one row.

I'm new to sql so explaining is hard for me.

thanks

jweissig

hi,

if you just want a total then something like the following should work.

select count(*) as total from tablename where question like = '%phone%';

this will give you a total # of rows found where question has a keyword of phones.

You can also do select count(*) as total from tablename;

this will give you the total number of rows for that table;

i assume you are using MySQL if you are using a differient database you might have to change the quiry a little in the "where like = '%phones%'" part.

thanks, and i hope this helps,
- Justin