On Wed, Oct 17, 2001 at 06:25:49PM +0200, Ciprian A. wrote:
> I need to select from a table all the records that do not contain a certain
> string. Any idea how I can do this?
You mean like SELECT * FROM TABLE WHERE FIELD NOT LIKE "%stuff%"? :)
--
Michael T. Babcock
http;//www.fibrespeed.net/~m
"Ciprian A." wrote:
> Hi,
>
> I need to select from a table all the records that do not contain a certain
> string. Any idea how I can do this?
>
> For example if I want to select all the fields that contain the string
> "my_string" I type:
> $ sel
CA> $ select * from table_name where column_name like "%my_string%".
select * from table_name where column_name NOT like "%my_string%".
;)))
-
Before posting, please check:
http://www.mysql.com/m
:
$ select * from table_name where column_name like "%my_string%".
How can I select all the other records that were not selected with the
above query?
Thank you,
Cip
-
Before posting, please check:
http://www.mysql.c
On 22-Aug-2001 Jeremy Morano wrote:
> Hi ,
>
> I was wondering if there was a way to retreive a column_name instead of a
> value in an sql select query?
>
> For example if my table has the fieldfirstname, lastname, telephone,
> movie1, movie2, movie3..
>
>
On Wednesday 22 August 2001 16:48, Jeremy Morano wrote:
>
> I was wondering if there was a way to retreive a column_name instead of a
> value in an sql select query?
>
> For example if my table has the fieldfirstname, lastname, telephone,
> movie1, movie2, movie3..
At 10:48 AM 8/22/01 -0400, you wrote:
>For example if my table has the fieldfirstname, lastname, telephone,
>movie1, movie2, movie3..
You haven't done a good job of database normalization. Those movies should
be broken out to their own table.
Onto what you were talking about, I kno
Hi ,
I was wondering if there was a way to retreive a column_name instead of a
value in an sql select query?
For example if my table has the fieldfirstname, lastname, telephone,
movie1, movie2, movie3..
And my first record is JohnDoe 555-
good
