Matthew Stuart wrote:
> I have a DB that has a field in it that currently just holds single or
> double numbers - these numbers are basically a reference to a category
> in which the particular record should be displayed. However I have now
> been asked if I can make it so that a particular record
Matthew Stuart wrote:
> I have a DB that has a field in it that currently just holds single or
> double numbers - these numbers are basically a reference to a category
> in which the particular record should be displayed. However I have now
> been asked if I can make it so that a particular record
Use CONCAT().
SELECT CONCAT('/',your_field,'/') 'newData' FROM your_table.
Then use similar logic to do an UPDATE statement, i.e. UPDATE your_table SET
your_field = CONCAT('/',your_field,'/')
You need to first make sure that the field you are trying to update is a
VARCHAR, because as it stands
