combine 2 select statement

[enterume]

Hi,

How can i combine the sql statement below into 1 ?

SELECT id from Users where name='bobo';
SELECT id from Users where name='Pete';

[Vex]

SELECT id from Users where name='bobo' or name='Pete';

[enterume]

Hi vex,

sorry i didn't stated it clear for question.

Actually I want the result to be like :

$result[0] = 'bobo'
$result[1] = 'pete'

Use the OR is the last option to me. The purpose I ask is just to explore more on this SELECT whether it allow to get result in this way.

Thanks
Louis

[OctoberAsh]

You can also write the SQL query this way, and achieve the same thing as the OR:

SELECT
ID,
Name
FROM USERS
WHERE Name IN('BoBo','Pete')

The result of this could then be processed through PHP to put it in the format from your example.

I'm starting to sound very "Johnny One-Note" here..🙂

Good luck!

[enterume]

I tried using IN, but the reult it will return also with 2 record. it is almost similiar as the solution given by Vex. So i will put in the while loop to get my data, and it would be faster that i seperate into 2 select statement.

Thanks everyone here.