mysql - Using wildcard in table data

Question

Using MYSQL I have a table where the data has wildcards. Example...

|ID  | Model  |
|1   | dv209% | 

I'm tryinh to write a sql query that will find row 1 when model='dv209AWW' or model='dv209asdfs'.

Any help would be appreciated.

Answer 1

use LIKE

select id, model
from your_table
where 'dv209AWW' like model
order by id