Selecting rows in columns

[Foops]

I'm kinda a noobie to mysql and mysql coding... I am entering a company that has alot of code that needs fixing...

One of the biggestest fixes is a search string written in ColdFusion that selects info from a table and displays it... Since I'm more comfy with php I'm going to rewrite the script, the only problem is, I need to select many different stock numbers from the same column. and example would be A1111X, B2222X and C1111X...

Here's the code as I have it now, can someone help me decipher what I'm doing wrong..

SELECT
FROM vehicles2
WHERE vehicles2.CSTOCKNUM = "X*"
ORDER BY 'CSTOCKNUM' DESC

Thanks ahead a time,
Foops

[bastien]

SELECT *
FROM vehicles2
WHERE vehicles2.CSTOCKNUM in ( $val1,$val2, $valn)
ORDER BY 'CSTOCKNUM' DESC

add single quotes if text values