[Resolved] Wildcards in Update query?

[edlentz]

I need to run an update query on many records in a mySql table. I can write the update query for one record but how do I make it step through the many other records? Is there a way to use wildcards? I tried % but it wouldn't work. This is what I tried:

update stck Set factoredproduct= 'yes' where prtn= '900.%%%%'

If I fill in the %%%% with a valid number then it works on just that one record. Any suggestions?

Thanks

[LordShryku]

you'll want to use LIKE instead of =

where prtn LIKE '900.%'

[edlentz]

Thanks, that worked great. Now the next question, how did I miss that one?