Mysql query selecting records

[patrickstrijdonck]

Hi,

i have a small problem with my, MYSQL query, i want to select all records except the records that has at field "lcursus" the date "0000-00-00" how can this be done, i know its a small thing.....

 

[jpadie]

select * from tableName where Icursus != '0000-00-00'

 

[patrickstrijdonck]

Like i said, Small thing ! lol

Anyway Thanks for the help Solved!