2007-01-23, 12:14 PM
|
#9
|
|
Former pr0n slinger.
Join Date: Aug 2003
Location: Antwerp, Belgium
Posts: 7,932
|
Quote:
Originally Posted by RedCherry
Good Morning All
Feeling MUCH better today after a full nights sleep and antibiotics to help calm the infection on my neck. The dr. also drained out some of the puss (YUCCH) so it doesn't feel like my neck is going to explode anymore. It is amazing what a difference 24 hours can make. 
Today I'm doing more work on theredcherry.com dividing up categories, moving sites around.
All you php geeks, since I work in my admin, is there a way to change things using a wildcard? I tried doing something like these examples:
Code:
update dl_sites set category='73' where category='17' AND elements='1=0,2=%,3=0'
update dl_sites set category='73' where title='%keyword%'
but it doesn't work. Also how do you use the term LIKE instead of the equal sign? Someday, I need to take classes in sql and php. I hate having to edit the suckers 30 at a time, that gets old when I could batch edit much faster. |
Try
Code:
update dl_sites set category='73' where title LIKE '%keyword%'
|
|
|