excluding info in query

[Lionel]

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

[sabret00the]

try

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

[Lionel]

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]!='???????????')

[akanevsky]

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

[Lionel]

I get a parse error both ways

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

thanks!!

[akanevsky]

What type of parse error?

[Lionel]

never mind, I edited my post, thanks

[akanevsky]

No problem :)