Fetch mysql data ignore some value

Question

How to get mysql data with ignore some value? The logic :

SELECT name,country 
 FROM person 
WHERE name!=jonathan and name!=fedrick and country!=italy

You practically have the query right there. Just fix your quoting issues. — John Conde
– John Conde, Commented Dec 16, 2013 at 1:55
See stackoverflow.com/questions/11321491/… for quoting examples and in SQL, <> is the preferred operator for "not equal to" although != is supported by MySQL. — Michael Berkowski
– Michael Berkowski, Commented Dec 16, 2013 at 2:00

Eric T · Accepted Answer · 2013-12-16 02:05:58Z

2

As John Conde comment, you just need the quotes. You probably need quotes for string while integer can go without quotes.

SELECT name,country FROM person WHERE name!='jonathan' and name!='fedrick' and country!='italy'

answered Dec 16, 2013 at 2:00

Eric T

1,0264 gold badges20 silver badges42 bronze badges

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

1 Comment

You have a quote out-of-place, see name!='fedrick and'