mysql field manipulation

[murph7185]

I'm guessing what I want to do is fairly easy but I'm pretty new with php. But here it is, I want to manipulate a certian row in mysql database like this. Ok here is an example of what the field looks like under "description":

USE PART# 0675-336

Here is the logic i want to use but I dont know how to put it into code:

if (in description row) (first 9 characters) = USE PART#
print: <a href="www.link.com/script.php?part=(characters 11-18)">Please click here for updated part number</a>

else (print that column)

I hope this makes sense in text words, i want it to see if the first 9 letters = USE PART# (in description row) and if they do print the part number in a link, if they dont print that column

Thanks,
Murphy

[bastien]

//assume data value called $partno

if (stristr($partno,"USE PART #")){ //check for string
$pn = split($partno, "#"); //split the string into array on #
$partno=$pn[1]; //array is 2 parts 0,1 use item 1
}
print: <a href="www.link.com/script.php?part=$partno">Please click here for updated part number</a>

hth