MySQL - Select Count help !

[Vxrcorsa90]

Hi All,

I was wondering if someone could help me on the following issue im having.

I have imported a .csv into a mysql table. The contents of the .csv is :


171767567,(agent_name)
171767681,(agent_name)
171770100,(agent_name)
171770316,(agent_name)


So so there are 2 x columns, 1 = Account which represents the numeric values, and is a INT type. 2nd column is Agent and represents the agent_name.

This is where im having trouble, i want to extract how many chats a particular agent has taken in accordance to the account id.

For example this is the mysql command im running :

select count(*) from csa_totals where Account like "1%" and Agent in ("agent_name");

Now the Count value returns 0.. which is odd because the data exists or perhaps im doing something wrong...

So to sum up i need to find how many chats an agent has taken depending on the Account type... ie. 1% i would assume means anything starting with 1..

Could anyone please advise...?

Thanks !

[sunfighter]

Use Agent = "agent_name" and see what you get.

[guelphdad]

Did you look at the table to see if the import worked correctly? if you imported incorrectly all the data could be in a single field for each row.

[Old Pedant]

How about:

select LEFT(Account,1) AS accountType, count(*) AS theCount
FROM csa_totals 
WHERE Agent = 'joe schmo'
GROUP BY LEFT(Account,1)
ORDER BY accountType

This assumes that the first digit specifies the account type. If it's more complex than that (e.g., "1%" is one account type, "20%" through "24%" is another, "25%" through "29%" is another etc.) let me know.