Take a look at the REPLACE() function: http://www.mysql.com/doc/en/String_functions.html#IDX1202
Regards, Mike Hillyer www.vbmysql.com > -----Original Message----- > From: Nick Stuart [mailto:[EMAIL PROTECTED] > Sent: Monday, June 23, 2003 8:58 AM > To: MySQL List > Subject: Replacing text on query.. > > > Hello all. I was wandering if it was possible to do a general > replacement of text on a query. What I want to do is for any > fields that > equal 'false' to be replaced with 0 and any fields that equal > 'true' be > replaced with 1. > > Now I know you can do if statements, but I have a whole bunch > of fields > and don't really want to go down the route on all of the > fields. But if > I have to I will. > > Thanks for the advice! > -Nick > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/mysql?> [EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
