Good Radio Show Tuesday (I Think)

[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:

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.

[docholly]

Originally Posted by RedCherry

Good Morning All

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.

maybe one of the topic on the radio show could be a comparative study of boils on adult webmasters using Jim's & yours as examples.

[Fonz]

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:

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

update dl_sites set category='73' where title LIKE '%keyword%'

[cd34]

Originally Posted by RedCherry

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

update dl_sites set category='73' where category='17' and elements in (1,2,3);

update dl_sites set category='73' where title like '%keyword%';