Good Radio Show Tuesday (I Think)

Fonz · 2007-01-23, 12:14 PM

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%'