PHP SQL

  • Kurthead+1
  • Graduate
  • Graduate
  • Kurthead+1
  • Posts: 131

Post 3+ Months Ago

I need to DELETE WHERE two columns have a certain value (Not a matching value).
Example db:
user_name = bobby,
file_name = test

DELETE WHERE user_name = 'bobby' & file_name = 'test'

Delete a row where two columns have the value I check for, how do I accomplish this?
  • Kurthead+1
  • Graduate
  • Graduate
  • Kurthead+1
  • Posts: 131

Post 3+ Months Ago

I think I found it actually. You just have to replace & with AND haha.

DELETE WHERE user_name = 'bobby' AND file_name = 'test'

Post Information

  • Total Posts in this topic: 2 posts
  • Users browsing this forum: No registered users and 87 guests
  • You cannot post new topics in this forum
  • You cannot reply to topics in this forum
  • You cannot edit your posts in this forum
  • You cannot delete your posts in this forum
  • You cannot post attachments in this forum
 
cron
 

© 1998-2014. Ozzu® is a registered trademark of Unmelted, LLC.