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 Shaun E on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

delete from database

Status
Not open for further replies.
cnw40007

cnw40007

Technical User
Mar 4, 2003
35
IE
Hi I have a mysql database with various email addresses.There are a number of blank rows that i want to get rid of. Ive tried delete from addsubj values ('',''); but nothing happens. Can anybody help me please. Thanks cnw40007
 
Sort by date Sort by votes

delete from yourTable
where addsubj is null
or trim(adjsub) = ''

The term blank is somewhat ambiguous. Does it mean NULL or is it an empty string or is it filled with space characters? The statement above should work for all of those.
 
Upvote 0 Downvote
OK great i tried that and it worked.Thanks again for your help.
cnw40007
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

penguinspeaks
  • Locked
  • Question
Update column based on input from another column 3
Replies
6
Views
762
penguinspeaks
penguinspeaks
wilsjay22
  • Locked
  • Question
Freeing up disk space from information_schema
Replies
1
Views
590
jg2828
jg2828
Arthur Lewis
  • Locked
  • Question
Backup Mysql database to client machine
Replies
2
Views
305
Arthur Lewis
Arthur Lewis
Colin Burton
  • Locked
  • Question
Sending A a video clip to either a web server or MySql Database
Replies
2
Views
376
Colin Burton
Colin Burton
martinkaeser
  • Locked
  • Question
MySQL Query for incrementing field from duplicates in database
Replies
4
Views
421
martinkaeser
martinkaeser

Part and Inventory Search

Sponsor

Back
Top