[johnnyburst79]

I'm trying to select two rows from two columns and while I can select the columns, the selection of multiple rows is not falling into place. I can pull one row into the report, but not two.

This is what I'm writing

SELECT name, number FROM table
WHERE name='variable1','variable2'

Something is occurring around the , between variable1 and variable2. I know I doing something wrong, but can't figure it out. I can pull variable1 by itself just fine.

The specific error is:
sql: errorYou have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' 'variable2' at line 2
number: 1064

Any ideas would be greatly appreciated. I tried searching and could not find an answer to this problem.

[MMJ]

I think you would have to make that two separate statements.

http://www.faqs.org/docs/ppbook/x5802.htm

[johnnyburst79]

Nope, tried that, and this is the error I get:

sql: errorYou have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT name, number FROM table WHERE name='variable2'' at line 4
number: 1064

Use of AND in WHERE name='variable1' AND 'variable2' removes the variables from the rows. The columns show, but the rows are missing.

[MMJ]

SELECT name, number FROM `table` WHERE name = var2

[johnnyburst79]

That's what I wrote in there, same error.

[MMJ]

Sorry:
SELECT FirstName, LastName FROM `person` WHERE FirstName = 'Peter'

I just tried that, worked fine.

What are you using for the queries?

[johnnyburst79]

This is what worked for me:

SELECT name, number FROM table
WHERE name IN('var1', 'var2', 'var3')

[MMJ]

One way:

select name, population FROM `bbc` where name = 'France';
select name, population FROM `bbc` where name = 'Germany';
select name, population FROM `bbc` where name = 'Italy';

Anther way:

select name, population FROM `bbc` where population > '57100000' AND population < '83500000' AND region = 'Europe' LIMIT 0,3



I think there is a way to do this. This is a bit weird.

[johnnyburst79]

When I did what you had, this is what the script checker gave me in PostgreSQL: sql: errorERROR: syntax error at or near "`" at character 30
number: 7
sql: errorERROR: syntax error at or near "`" at character 30
number: 7
sql: errorERROR: syntax error at or near "`" at character 30
number: 7

In MySQL5, I got this:
name population
France 60700000
name population
Germany 82500000
name population
Italy 57200000

Using the script I posted above, it shows this:
name population
France 60700000
Germany 82500000
Italy 57200000

[MMJ]

Yeah, the "Another way:" works correctly.

So IN was it.

Interesting.