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 :
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 :
Now the Count value returns 0.. which is odd because the data exists or perhaps im doing something wrong...Code:select count(*) from csa_totals where Account like "1%" and Agent in ("agent_name");
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...?