On Fri, Jan 31, 2003 at 02:07:11PM -, Kevin Smith wrote:
> Hi All,
>
> Can anyone help me get this query working in MySQL, this was created using
> Access, but it doesn't port well for MySQL syntax:
>
> SELECT b.id, p.part_code, p.product_type, p.description, po1.options,
> b.price, b.quantit
Scott,
Saturday, October 05, 2002, 7:45:16 AM, you wrote:
SJ> I have a db with slightly over 614,000 records of names and addresses. In
SJ> the address column, there are quite a few records like
SJ> "123 any rd # 2"
SJ> "319 w. 1st st # B"
SJ> "4321 test blvd # 42"
SJ> etc
SJ> I want to replac
You almost got it. Your syntax will be something like this:
UPDATE Table SET address=REPLACE(address,'#','Number') WHERE column
like"%#%"
When I am trying to figure out the syntax for something, I always add a
LIMIT 1 at the end so that only one record gets changed.
On Saturday, October 5, 200
