excluding info in query
 

I am doing a query and would like to exclude all titles starting with 2.

how would I go about it?

select * from whatever where title does not start with '2'

thanks

try

SELECT * FROM table WHERE column NOT LIKE '2%'

Thanks. I couldn't get it from the calendar. So I am trying to get it another way

if ($eventinfo['calendarid']==6 AND $eventinfo['title']{0} != 2)

I get a parse error both ways

never mind, it works. I had an extra ")" in there.

thanks!!

What type of parse error?

never mind, I edited my post, thanks

No problem :)