onday, 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
> > e
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: Re
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
an
