MYSQL
I have a table with a date field. I have a query that needs to output
only if NOW()NOW()
ED3='1999-12-31 00:00:00'
the above query will output when ED3 is as above. NOW()='2001-09-15
18:10:44'
???
-
Before posting, ple
MYSQL
I have a table with a date field. I have a query that needs to output
only if NOW()NOW()
ED3='1999-12-31 00:00:00'
the above query will output when ED3 is as above. NOW()='2001-09-15
18:10:44'
???
-
Before posting, ple
This question involves table setup questions as much as it involves a
query question. Bare with me, this seems hard to explain.
I have a table that includes records with 3 (relevant to this
conversation) fields (actually 9..more on that later). Each of those
fields have 2 other related fields. i.
Title. I
need a more robost idea...
Ravi Raman wrote:
> hi.
>
> select Title, IF(Title LIKE "%TOMMY%", 1, 0) as check
> from inv where...
> ... order by check desc;
>
> hth.
> -ravi.
>
> -Original Message-
> From: Carl Schrader [mailto:[EMAIL PRO
I'm doing a query like:
select Title from inv where Title LIKE '%TOMMY%' OR Content LIKE
'%TOMMY%' OR Notes LIKE '%TOMMY%' order by Title
What I need is to have the results that match Title LIKE '%TOMMY%' to
appear first and then the rest. I have been doing 2 separate queries and
filtering th
I'm doing a query like:
select Title from inv where Title LIKE '%TOMMY%' OR Content LIKE
'%TOMMY%' OR Notes LIKE '%TOMMY%' order by Title
What I need is to have the results that match Title LIKE '%TOMMY%' to
appear first and then the rest. I have been doing 2 separate queries and
filtering the
I have a query that is using Group By Title.
Is there anyway to make 2 Titles such as "League of their own" and
"League of their own###" group as the same. I am removing the #'s in the
output but I still get 2 results - 1 for each. Ideas?
CRT (www.vandyke.com)
Tim Thorburn wrote:
> Hello,
>
> Can someone here recommend a good Telnet program (with SSH) that I can use
> to connect to my servers MySQL database?
>
> Preferably something shareware/freeware - but if it must be purchased, I'm
> not against that.
>
> Thank you
>
> -Tim
>
MUST do this
> server side, here is your query:
> select Title, IF(Title LIKE '%Green','Green','Blue') AS whatmatch
>
> - Original Message -
> From: "Carl Schrader" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent:
>
Is there anyway to determine which part of the an sql query where blahblah
produced
the result?
ie. select Title from inv where Title LIKE '%Green' OR Title Like
'%Blue%'
I need to distinguish if the Title was like Green or Blue..
-
Ok, thanks for the input. I'll work on optimizing the code and look at the
indexes.
ryc wrote:
> Changing to C++ is not likely to give you a noticable speed difference
> because your bottleneck is not the code but the queries. With proper
> database design you should be able to acheive those res
maybe some systems files
> was damaged.
>
> >From: Carl Schrader <[EMAIL PROTECTED]>
> >To: Mysql <[EMAIL PROTECTED]>
> >Subject: Speed question
> >Date: Wed, 16 May 2001 08:08:15 -0700
> >
> >I am searching to speed up an operation I have, which wo
h filed to build your result you should
> compact the query in to one i.e.
> if you are doing
> select MM from table1 where record_num = 3
> select Title from table1 where record_num = 3
> select Archive from table1 where record_num = 3
> then you should replac
I am searching to speed up an operation I have, which works - it just
takes minutes to finish. The current script is written in pike (a C like
scripting language). I believe that most of the overhead is the multiple
queries. Would using C++ be significantly faster? (I'd have to learn
some C before
I have 2 tables with a common field of Title.
Table 1 defined as:
Name;varchar(60)
Title;varchar(60)
Year;varchar(4)
Other;varchar(30)
Other2;varchar(30)
act_no;int(8) unsigned zerofill
Table 2 defined as:
MM;varchar(4)
Title;varchar(48)
Archive;varchar(4)
record_num;int(8) unsigned zerofill
I
15 matches
Mail list logo
