how do parse this?

ziggs

Hey. I am looking to parse this and I don't know what the wildcard symbol is for MySQL. I am looking to do something like "Select from forumposts where comment_to=''"; will that line work? I am just looking for any entry that has a value for comment_to. Also ANY VALUE! Thanks for anyones help.
Ziggs

P.S. Van don't make fun of me on this one. I am a little short on memory cells today.

Anon

SQL wild card is % (percentage sign).

Try this for your query.
Select * from forumposts where comment_to like '%'

which will give you every result with any value.

Select * from forumposts where comment_to like 'a%'

will give you anything that starts with the character "a".

ziggs

ahh ok...
Thanks!
Ziggs

David what is your AIM name..if you have one?
Mine is Chads2k2. If you ever feel like talking.

Anon

I don't use AIM, but I do use ICQ #24652599 if ya wanna holler at me. I am on all day at work usually. Just don't send me one of those "My name is Ziggs, 19 y/o hottie with a web cam ..."

lol

ziggs

Ahh comon David. Why not? Those messages are always fun! 🙂
Ziggs