Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Updating a column in table ?

Status
Not open for further replies.
maverick

maverick

MIS
Apr 21, 1999
193
0
0
US
In one field on all records I want to get rid of anything longer than 8 characters,

I tried: SELECT LEFT(`colName`, 8);

It didn't work of course... hehehe

Can someone enlighten me?

thanks,
Mav
 
Sort by date Sort by votes
well, SELECT would retrieve the data

did you want to update it?

try the UPDATE statement then :)

r937.com | rudy.ca
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

boylesg
  • Locked
  • Question
Can't sort my table by a particular column, records are returned in autinc order.
Replies
4
Views
240
spamjim
spamjim
lupidol
  • Locked
  • Question
Cannot create new table in mySQL 3
Replies
6
Views
228
lupidol
lupidol
penguinspeaks
  • Locked
  • Question
Update column based on input from another column 3
Replies
6
Views
202
penguinspeaks
penguinspeaks
EdLentz
  • Locked
  • Question
How do I use a keyword in a query??
Replies
6
Views
215
EdLentz
EdLentz
BobThornton
  • Locked
  • Question
Drop/Truncate tables based on a stored procedures value 1
Replies
6
Views
232
BobThornton
BobThornton

Part and Inventory Search

Sponsor

Back
Top