How to find multiple values from one table?

Question

SELECT *
FROM `engine4_user_fields_values`
WHERE (field_id = 3) AND (value = 'test7') AND (field_id = 4)
  AND (value = 'test7') AND (field_id = 13) AND (value = 'Hemraj')


field_id | value
-----------------------------
3  | test7
4  | test7
13  | Hemraj

How to find this values?

When I use or operator it's showing two values or one value. My requirement is if not found any of this one then can't display.

Possible duplicate of [How can I prevent SQL injection in PHP?](http://stackoverflow.com/questions/60174/how-can-i-prevent-sql-injection-in-php) — , Oct 26 '16 at 10:09

score 0 · Answer 1 · answered May 27 '16 at 09:28

0

Like this?

SELECT *
FROM `engine4_user_fields_values`
WHERE 
  (field_id = 3 AND value = 'test7') OR 
  (field_id = 4 AND value = 'test7') OR 
  (field_id = 13 AND value = 'Hemraj')

answered May 27 '16 at 09:28

Pyton

1,291
8
19

its showing two values when one value not matching. – May 27 '16 at 09:33
My requirement is if not found any of this one then can't display. – May 27 '16 at 09:33

score 0 · Accepted Answer · answered May 27 '16 at 09:28

0

Hope this helps.

SELECT Value 
FROM `engine4_user_fields_values`
GROUP BY Value
HAVING COUNT(*) >1

answered May 27 '16 at 09:28

Sandesh

1,036
5
13

score 0 · Answer 3 · answered May 27 '16 at 11:35

0

If you just want to see if all the values are there:

SELECT (CASE WHEN COUNT(*) = 3 THEN 'ALL PRESENT' ELSE 'MISSING FIELD' END)
FROM `engine4_user_fields_values`
WHERE (field_id = 3 AND value = 'test7') OR 
      (field_id = 4 AND value = 'test7') OR 
      (field_id = 13 AND value = 'Hemraj')

answered May 27 '16 at 11:35

Gordon Linoff

1,242,037
58
646
786

if all present how to display this values? – May 27 '16 at 12:01
@HemrajPal . . . Is there a reason why you unaccepted this answer? – Gordon Linoff Dec 05 '16 at 13:06

How to find multiple values from one table?

3 Answers3