php mysql one table two field separate search result

Question

I've mysql one table with two field object1 and object2. A separate query search result by typing in ID on input form only any ID that match object1 with 222 and 333 will return a query result of a same row of the ID.

The same for object2 by typing ID that match with object2 with 444 and 999 will return a query result of a same row of the ID.

For example, type in 12345 in input form and a result will show Joe Long object1 (instead of 222)

Can anyone think of sql and php please?

For example if I search by ID 12345 then I want get result as Joe Long, object1.

 +-----------------------------------------------------------------+
 | ID        | firstName   | lastName | object1 | object2 | sortID |
 +-----------------------------------------------------------------+
 | 12345     | Joe         | Long     |  222    |    444  |   66   |
 | 12346     | John        | Higgins  |  222    |    444  |   66   |
 | 12347     | David       | Crowe    |  333    |    444  |   66   |
 | 12348     | Denise      | Jacob    |  333    |    999  |   77   |
 | 12349     | George      | Jacob    |  333    |    999  |   77   |
 | 12350     | Iain        | Jacob    |  111    |    444  |   66   |
 | 12351     | Kevin       | Dalglish |  888    |    555  |   77   |
 | 12352     | Christina   | Brown    |  888    |    555  |   77   |
 | 12353     | Jean        | Scholes  |  888    |    555  |   66   |
 | 12354     | Angela      | Scholes  |  333    |    555  |   77   |
 | 12355     | Ellie       | Scholes  |  333    |    555  |   77   |
 +-----------------------------------------------------------------+

so, you-wish-to-hire-a-programmer-for-you?

hjpotter92
– hjpotter92

2012-04-24 23:03:09 +00:00
Commented Apr 24, 2012 at 23:03 — hjpotter92
– hjpotter92, Commented Apr 24, 2012 at 23:03
I can only wish and I need to learn.

Irishgirl
– Irishgirl

2012-04-24 23:06:30 +00:00
Commented Apr 24, 2012 at 23:06 — Irishgirl
– Irishgirl, Commented Apr 24, 2012 at 23:06

Seabass · Accepted Answer · 2012-04-24 23:07:36Z

1

Probably something like:

select *
from `table`
where object1 like '%query%' or object2 like '%query%'
group by ID 
order by sortID asc

answered Apr 24, 2012 at 23:07

Seabass

1,97312 silver badges15 bronze badges

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

2 Comments

Irishgirl Over a year ago

Ok Zenbait. Does this will return as Joe Long object1 (instead of 222) for one person?

Irishgirl Over a year ago

Is it possible to narrow it down to object1 222 and 333 for if a user type in a ID 12345 and Joe Long will appear as a result? The same for object2 444 and 999 if a user type ID 12350 and Iain Jacob will show as a result.

Collectives™ on Stack Overflow

php mysql one table two field separate search result

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related