Max date to max date

•

What is DaniWeb IT Discussion Community?

You're currently browsing the MySQL section within the Web Development category of DaniWeb, a massive community of 374,142 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 3,472 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.

Join our community!

Please support our MySQL advertiser:

Thread Tools Display Modes

Views: 572 | Replies: 4

•

Join Date: May 2008

Posts: 4

Reputation: stonyheng is an unknown quantity at this point

Rep Power: 0

Solved Threads: 0

stonyheng

Offline

Newbie Poster

Max date to max date

May 16th, 2008

Hi all,

I wonder if it is possible that someone can drop me a code or something on this particular problem which I am currently dealing with.

in_date out_date
18/03 30/04
20/04

So how am i supposed to pair up 30/04 and 20/04 as 1 pair and show it up in the table? Many thanx in advance

•

Join Date: Apr 2008

Posts: 43

Reputation: Daedal is an unknown quantity at this point

Rep Power: 1

Solved Threads: 11

Daedal

Offline

Light Poster

Re: Max date to max date

May 20th, 2008

Here is an example... could you try to be more specific?

This will select records with an in_date of '%-03-18' or out_date of '%-04-20':

Help with Code Tags

(Toggle Plain Text)

SELECT * 
FROM table 
WHERE in_date LIKE '%-03-18' 
OR out_date like '%-04-20'

//Joe
Web Carpenter: Web Development, Graphic Design, Database Solutions

•

Join Date: May 2008

Posts: 10

Reputation: jemajoign is an unknown quantity at this point

Rep Power: 1

Solved Threads: 0

jemajoign

Offline

Newbie Poster

Re: Max date to max date

May 21st, 2008

If by 'pair up' you mean that you want them to appear in the same row, I think the approach would be to join the table to itself.

So if you had a table like:

Help with Code Tags

(Toggle Plain Text)

id	description	linkid
1	item 1		3
2	item 2		1
3	item 3		2

And you want a result like:

Help with Code Tags

(Toggle Plain Text)

leftdescription	rightdescription
item 2		item 1
item 3		item 2
item 1		item 3

A query like this should do it:

 Help with Code Tags 
 MySQL Syntax (Toggle Plain Text) 
CREATE TABLE if NOT EXISTS link2myself(id INT, description VARCHAR(6), linkid INT);
INSERT INTO link2myself(id,description, linkid)
SELECT 1, 'item 1', 3 UNION
SELECT 2, 'item 2', 1 UNION
SELECT 3,'item 3', 2;
 
SELECT me.description leftdescription, otherme.description rightdescription
FROM link2myself me
JOIN link2myself otherme on me.linkid=otherme.id;
 
DROP TABLE link2myself;
create table if not exists link2myself(id int, description varchar(6), linkid int);
insert into link2myself(id,description, linkid)
select 1, 'item 1', 3 union
select 2, 'item 2', 1 union
select 3,'item 3', 2;

select me.description leftdescription, otherme.description rightdescription
from link2myself me
join link2myself otherme on me.linkid=otherme.id;

drop table link2myself;

•

Join Date: Mar 2008

Posts: 169

Reputation: Traicey is an unknown quantity at this point

Rep Power: 1

Solved Threads: 16

Traicey

Offline

Junior Poster

Re: Max date to max date

May 26th, 2008

Lets say you really dont want to create a table and you dont want to join tables but concatenating two records from one table instead...........

I think you need to be more specific coz what u said above is completely unclear

Last edited by Traicey : May 26th, 2008 at 11:50 am.

•

Join Date: May 2008

Posts: 10

Reputation: jemajoign is an unknown quantity at this point

Rep Power: 1

Solved Threads: 0

jemajoign

Offline

Newbie Poster

Re: Max date to max date

May 26th, 2008

Just as a note, the 'CREATE TABLE' is used to create a sample table with some sample data. It has no relation to the solution. In practical usage, you would use the table you already have.

Also, if you want to string concatenate some rows you can use the aggregate function group_concat(). But if you want them to appear as separate columns, use join.