Using CASE for store values

Hi allit's possible to use the CASE clause in MySQL like this:SELECT statusID, Case(statusID = 1, TotalStatus1=TotalStatus1 + 1) Case(statusID = 2, TotalStatus2 = TotalStatus2 +1) It's possible? How to do that? Thanx for your time.Crie seu Yahoo! Mail, agora com 100MB de espaço, anti-spam e antivír

Returning where COUNT > 5

Hi all how to do this in MySQL? Returning only records with COUNT > 5? SELECT `groups`.`groupsDescr`, `roles`.`roles_Agroup`, `roles`.`rolesDescr`, COUNT(`roles`.`rolesDescr`) AS TOTAL FROM `roles` INNER JOIN `groups_roles` ON (`roles`.`rolesID` = `groups_roles`.`fkrolesID`) INNER

Using IF clause

Hi my table have an field when users can enter any chars If users dont send any content for that field(phone), mysql store "( ) - " without quotes in that What im looking for: Display IF phone field is ( ) - NOT ENTER Otherwise display the phone of user. It's possib

Backing up InnoDB MySQL DB

Hi all we're using MySQL 4.0.12 with InnoDB... please do you have any scripts, comments, suggestions, ideas, tutorials... about how to backup from that DB? It's possible to? Thanx for your time. Diga-me e eu esquecerei Mostre-me e lembrarei Ensina-me e aprenderei -