[RESOLVED] Search in two columns

[sidsel]

I have a query that do a search in two columns, product_line and product_description.

Ie. SELECT * FROM table WHERE product_line LIKE '%input%' OR product_description LIKE '%input%' ORDER BY item_number ASC

How do I modify the query so all rows where "input" is found in product_line are listed first and then all other rows?

[NogDog]

SELECT *, IF(product_line LIKE '%input%', 1, 0) AS sort_order
FROM table
WHERE product_line LIKE '%input%' OR product_description LIKE '%input%'
ORDER BY sort_order ASC, item_number ASC