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 possible? Using IF clause Mysql give me an error - maybe IF(`users`.`phone` IS '( ) - ','NOT ENTER',`users`.`phone`) AS phonefield; What's happened? Thanx for your time
Diga-me e eu esquecerei Mostre-me e lembrarei Ensina-me e aprenderei --------------------------------- Yahoo! Mail - Participe da pesquisa global sobre o Yahoo! Mail. Clique aqui!