Mysql Query Question

[fluiduk]

Hi Guys

Could anyone help me with the syntax for a query that deletes all records that begin with a certain character?

Any help appreciated

Thanks

 

[meghatronic]

Hi Guys

Could anyone help me with the syntax for a query that deletes all records that begin with a certain character?

Any help appreciated

Thanks

Use Like %%

 

[toString]

delete from table where row like 'K%'

 

[fluiduk]

Thanks guys will give it a whirl

Aaron