Another quick MySQL Quiz!

A few q's about LIKE and NOT LIKE

[ahmedtheking]

I am trying to pull some stuff out of my database with PHP and MySQL, but I can't seem to figure out how to put this together:

SELECT * FROM WebSite where pgname NOT LIKE 'pr%' and 'cn%' and 'cl%' and 'sv%'

If you don't get the gist of it, I want all the rows in the database as long as they dont begin with pr, cl, cn or sv.

I had a look @ the MySQL site and just got lost!

[Salsa]

I think you just need to use a NOT LIKE before each condition, e.g.:

SELECT * FROM WebSite WHERE pgname NOT LIKE 'pr%' AND pgname NOT LIKE 'cn%' AND pgname NOT LIKE 'cl%' AND pgname NOT LIKE 'sv%'

...there may be a shortcut to this, but I don't know it.

I hope this helps.

[ahmedtheking]

Yea that worked! thank you!

[ergophobe]

Hey! Don't you owe Salsa a gold star?

[jatar_k]

I think Salsa's little book of gold stars is full, I'll have to go out and get another. ;)

[ahmedtheking]

Gold stars!? I hope one day I'll be competent enough to get one! :D

[ergophobe]

It was a quiz and he aced it. I thought he was supposed to get a gold star (BTW, for those not of certain nationalities and certain ages, this might not make sense).

[Salsa]

Aw, shucks. 'Twernt nothin'. No stars are necessary. Simply the gold will be fine.

;)

Ergophobe: Yes, I remember the gold stars. We'd get them for acing quizzes and also for just being "a good doobee." Now I'm really dated.