RE: [PHP-DB] Select rows where ?

2002-02-12 Thread Gurhan Ozen 

SELECT * FROM table WHERE COLUMN_NAME NOT LIKE '%unwanted_String%';

when the field type is number you can use

SELECT * FROM table WHERE COLUMN_NAME != unwanted_number;
or
SELECT * FROM table WHERE COLUMN_NAME <> unwanted_number;

Gurhan


-Original Message-
From: Dave Carrera [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, February 12, 2002 1:39 PM
To: php List
Subject: [PHP-DB] Select rows where ?


Hi All
How do I select the rows that DO NOT contain a certain character.

I.e. : select * from tablename where field dose not contain "A"

Any pointers as always appreciated.

davec

Dave Carrera
Website Designer
http://www.davecarrera.com
 



-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Select rows where ?

2002-02-12 Thread Jim Lucas [php] 

select * from table where column<>"something"
select * from table where column NOT LIKE "%something%"

Jim Lucas
- Original Message - 
From: "Dave Carrera" <[EMAIL PROTECTED]>
To: "php List" <[EMAIL PROTECTED]>
Sent: Tuesday, February 12, 2002 10:39 AM
Subject: [PHP-DB] Select rows where ?


> Hi All
> How do I select the rows that DO NOT contain a certain character.
> 
> I.e. : select * from tablename where field dose not contain "A"
> 
> Any pointers as always appreciated.
> 
> davec
> 
> Dave Carrera
> Website Designer
> http://www.davecarrera.com
>  
> 
> 
> 
> -- 
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
> 
> 


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

RE: [PHP-DB] Select rows where ?

2002-02-12 Thread Rick Emery 

select * from tablename where field NOT LIKE "%A%";

-Original Message-
From: Dave Carrera [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, February 12, 2002 12:39 PM
To: php List
Subject: [PHP-DB] Select rows where ?


Hi All
How do I select the rows that DO NOT contain a certain character.

I.e. : select * from tablename where field dose not contain "A"

Any pointers as always appreciated.

davec

Dave Carrera
Website Designer
http://www.davecarrera.com
 



-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php