mysql search multiple values that has the same column value

Question

Eddited to more accurate problem:
i have a table: id, supplierCode, propertyCode, specification. While doing search in products i would like to get products that specifications has a text like value1 and value2, so to get those products i would like an query sumething like this:
SELECT * FROM tbl WHERE (specification LIKE '%value1%' OR specification LIKE '%value2%') AND (those 2 got rows has the same supplierCode)
Or from other side of problem: Get all supplierCode's where whatever rows with same supplierCode has in the specification columns LIKE '%value1%' AND LIKE '%value2%'
Example:
id supplierCode propertyCode, specification
1 001234 11 i7-blabla
2 001234 13 15.3"
3 004321 15 i7-9761
4 004321 16 15.4"
5 003214 14 i7-15.3"

And if i'm searching for 'i7' and '15.3"' i could get 001234 and 003214 becouse they has i7 and 15.3" in their specifications

you only need the % when you are using LIKE, not when you are using =. An IN statement would already be a better choice then using the OR operator — arnoudhgz
– arnoudhgz, Commented Aug 6, 2012 at 22:49

arnoudhgz · Accepted Answer · 2012-08-06 23:26:53Z

1

You can use the IN clause--definitely research thi problem a bit more, you would've definitely found a solution somewhere in the web.

    SELECT * FROM tbl 
    WHERE specification IN ('value1', 'value2')
      AND propertyCode = 'SOME_VALUE'

edited Aug 6, 2012 at 23:26

arnoudhgz

1,2849 silver badges19 bronze badges

answered Aug 6, 2012 at 22:50

Roberto Navarro

9584 silver badges16 bronze badges

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

1 Comment

Benas Radzevicius Over a year ago

ups, srry, i meant 'LIKE' not '='

John Woo · Accepted Answer · 2012-08-06 22:48:46Z

0

use LIKE instead of = sign

SELECT * 
FROM tbl 
WHERE (
       specification LIKE CONCAT('%', value1, '%') OR 
       specification LIKE CONCAT('%', value2, '%') 
      ) AND 
      propertyCode = valueHere

but if you are sure with the specification values use IN instead of OR (actually they are the same)

SELECT * 
FROM tbl 
WHERE  specification IN ('value1','value2') AND 
       propertyCode = valueHere

answered Aug 6, 2012 at 22:48

John Woo

265k70 gold badges509 silver badges500 bronze badges

1 Comment

Razvan Over a year ago

his problem is "AND (has the same propertyCode)"

MKT · Accepted Answer · 2012-08-06 22:52:30Z

0

you can use like keyword

pattern matching

answered Aug 6, 2012 at 22:52

MKT

6751 gold badge6 silver badges18 bronze badges

Comments

Razvan · Accepted Answer · 2012-08-06 22:53:00Z

0

 SELECT * FROM tbl 
 WHERE (specification='%value1%' OR specification='%value2%') 
 group by propertyCode

answered Aug 6, 2012 at 22:53

Razvan

10.2k6 gold badges41 silver badges51 bronze badges

Comments

Andrew · Accepted Answer · 2012-08-06 22:54:15Z

0

$find = mysql_query("SELECT * FROM `tbl` WHERE (`specification` LIKE '%$value1%' OR `specification` LIKE '%$value2%') AND `propertyCode`='$propertycode'")or die(mysql_error());
$display = mysql_fetch_array($find);

Bare in mind you will need to change the PHP variables as you have not included any I have to presume you are looking for something like the above.

Also if you are looking to create a list then you will need to use a while statement on your fetch.

answered Aug 6, 2012 at 22:54

Andrew

3592 gold badges6 silver badges21 bronze badges

Collectives™ on Stack Overflow

mysql search multiple values that has the same column value

5 Answers 5

1 Comment

1 Comment

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

1 Comment

1 Comment

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related