,
I'm still stuck though
I did as you suggested
- Original Message -
From: Jed Verity [EMAIL PROTECTED]
To: julian haffegee [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Friday, September 06, 2002 3:42 AM
Subject: Re: select statements
Hello, Jules,
You can use the value in (a,b
Hi, Rob,
Easily resolved. Use 'not like' in conjunction with 'like':
WHERE ((title like '%man%') or (title like '%men%')) and title not like
'%woman%' and title not like '%women%'
Does that work? HTH!
Jed
On the threshold of genius, Rob Gambit wrote:
Hello MySQL mailing list.
I am having
but not cats
or catalog
I had thought to search for '% cat %' but the keyword
could be at the beginning of the title, or the end, be
followed by a . or a space. *shrug* probably need to
think up something with RLIKE maybe.
--- Jed Verity [EMAIL PROTECTED] wrote:
Hi, Rob,
Easily
Does this work?
select t.id,t.option,t2.option from tableName t left join tableName t2 on
t.id=t2.id and t2.option!=t.option where t.option=a and isnull(t2.option);
HTH,
Jed
On the threshold of genius, [EMAIL PROTECTED] wrote:
I apologize for asking such a basic SQL question, but I am
Hello, Jules,
You can use the value in (a,b,c) format. If necessary, implode your array
and do something like this:
SELECT emailAddress FROM subscribers_html WHERE mailingGroup value in
($toText);
Check the documentation, if necessary, for usage of implode and value in.
HTH!
Jed
On the
I'm a little surprised that MySQL isn't giving you an error on the ambiguity
of manufacturersID=12. What happens if you specify
tableName.manufacturersID=12?
HTH,
Jed
On the threshold of genius, Wilbert Enserink wrote:
Hi all,
I'm having troubles with a good selection statement in my
Hello, Abhilash,
If you just want the number of days between two dates, you don't need
FROM_DAYS. FROM_DAYS gives you a date. This should be all you need:
Select TO_DAYS(CURDATE()) - TO_DAYS('2001-08-30');
HTH,
Jed
On the threshold of genius, [EMAIL PROTECTED] wrote:
Hi,
My intention is
How about
select a.name from table1 a, table2 b where a.name like
concat(%,b.name,%);
You might want to read chapter 6.3 in the mysql manual:
http://www.mysql.com/doc/en/Functions.html
HTH,
Jed
On the threshold of genius, Jorge Martinez wrote:
yes, but select a.name from table1 a, table2 b
Hi, Jerry,
Here's your simplified form:
form action=addcontacts.php method=post
input name=firstName type=text
input name=lastName type=text
input name=email type=text
/form
Here is the page addcontacts.php:
html
body
?
if ($REQUEST_METHOD == POST) {
$usr =
Hello, Gigi,
By decoded, do you mean that you want the words Author and Publisher
to appear in your table instead of 1 and 2? And you can't create or
modify tables? Short of replacing the codes in the columns, it seems to me
that you'd need to have a decode table. Something like:
the DB structure.
Gigi
-Messaggio originale-
Da: Jed Verity [mailto:[EMAIL PROTECTED]]
Inviato: venerdì 5 luglio 2002 20.16
A: Gigi Di Leo; '[EMAIL PROTECTED]'
Oggetto: Re: Query problem
Hello, Gigi,
By decoded, do you mean that you want the words Author and Publisher
Hi, Matthew,
Have you tried:
insert into test (test) values ('work')
Or
update test set test='test'
I liked it when Matthew Hajda wrote this to me:
Hello,
I am having some issues inserting and updating with mySQL.
Database: asdf
Table: test
field: idfield (int, autoincrement)
You need a LEFT JOIN. Read about it here:
http://www.w3schools.com/sql/sql_join.asp
Go down to the LEFT JOIN section.
HTH,
Jed
I liked it when Chris Griffin wrote this to me:
If this is not the right list for this please direct me to the proper
list.
I have a table of name/address
~)~)~)~)~)~)~)~)~)~)~)~)~)~)~)~)~)~)
Jed Verity
Chief Technology Officer
Communication Works
Pier 9 Embarcadero, Suite 116
San Francisco, CA 94111
www.communicationworks.org
Direct: 415-255-1946
Fax:415-255-1947
Email: [EMAIL PROTECTED
14 matches
Mail list logo