MySQL - Duplicate rows by different column

Question

I have a table with the following structure:

id | user_id | job | type

The scenario is as following:

"A person in a company is offering his skills, another person is looking for skills. They can fill in their offerings and searches. After filling this in, they need to see the matches between what they are looking for and others are offering."

So "job" is a string, f.e. "creating backup","repairing bike"
So "type" is a string, f.e. "searching", "offering"

Is it possible to get these matches with one query?

** edit **

id | user_id | job           | type
---|---------|---------------|----------
1  | 1       | Create backup | searching
2  | 1       | Format osx    | searching
3  | 2       | Create backup | offering
4  | 1       | Program PHP   | offering

I want to do a query SELECT * FROM table WHERE user_id = 1 AND type = 'offering' ... with a result that provides me an array of all the other users that are offering this. So that the user has a page with all the results of people that are offering the job that he is searching.

can you provide a sample of the results you want

Marshall Tigerus
– Marshall Tigerus

2014-04-29 16:27:42 +00:00
Commented Apr 29, 2014 at 16:27 — Marshall Tigerus
– Marshall Tigerus, Commented Apr 29, 2014 at 16:27
Cant get your objective from this

Babu
– Babu

2014-04-29 16:40:25 +00:00
Commented Apr 29, 2014 at 16:40 — Babu
– Babu, Commented Apr 29, 2014 at 16:40

MinhD · Accepted Answer · 2014-04-29 16:43:58Z

2

This will get you all user offering skills which are searching. Try it:

SELECT o.* FROM Table1 s 
INNER JOIN Table1 o 
ON s.job = o.job
WHERE s.type = 'searching'
AND o.type = 'offering'
AND s.user_id = (The user who is searching)

answered Apr 29, 2014 at 16:43

MinhD

1,84812 silver badges14 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

MySQL - Duplicate rows by different column

1 Answer 1

Comments

Your Answer

Collectives™ on Stack Overflow

MySQL - Duplicate rows by different column

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related