Display data flagged by one field

[Guest_imported]

I have a database with several fields. I wish to display only those lines of data containing "888" in field "aircode" on one result page and on another page all the lines of data NOT containing "888". How could I write these scripts?
Any help in any direction would be grateful.

Thanks

 

[mcvdmvs]

SELECT * FROM databasetable WHERE line ilike '%888%';

SELECT * FROM databasetable WHERE line NOT ilike '%888%';

You can use ~* as well (instead of ilike) check out SQL pages. mcvdmvs
-- "It never hurts to help" -- Eek the Cat

 

[Guest_imported]

Thanks for the help. much appreciated.
regards