Re: The opposite of where column_name LIKE %string%

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

The opposite of where column_name LIKE %string%

* 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.com/manual.php

Re: The opposite of where column_name LIKE %string%

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/manual.php (the manual) http

Re: The opposite of where column_name LIKE %string%

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: $ select * from table_name where column_name like %my_string

column_name

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

Re: column_name

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 know

Re: column_name

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.. And my first record

RE: column_name

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.. And my first record

RE: COUNT(DISTINCT Column_Name)

You can use: SELECT Column_Name, count(Column_Name) FROM Table_Name GROUP BY Column_Name -Original Message- From: Franz, Fa. PostDirekt MA [mailto:[EMAIL PROTECTED]] Sent: Friday, February 16, 2001 3:02 AM To: [EMAIL PROTECTED] Subject: COUNT(DISTINCT Column_Name) Hi Everybody