Combining 2 queries

anjanesh · #1 (**permalink**) 01-04-07, 14:17

Is there a way to combine this into 1 query ?

Code:

SELECT `Word` FROM `List` WHERE `Word` LIKE 'st%' LIMIT 0, 10
SELECT `Word` FROM `List` WHERE `Word` LIKE '%st%' LIMIT 0, 10

Problem is, I want the list of results from query1 first and then list from query2
So if there are 3 from query1 and 2 from query2, I want them in that order.

SELECT `Word` FROM `List` WHERE `Word` LIKE '%st%' ORDER BY `Word` ASC LIMIT 0, 10 is not the solution since it'll list the words starting from a.

Thanks