I'm trying to remove certain letters from part numbers but I'm having difficulties trying to get it working correctly.

This is where I'm at right now. It's non functional.

```
SELECT REPLACE(`part`, '[0-9]L', '') FROM `table` WHERE (`part ` LIKE '%[0-9]L')

```

Essentially say I have these five items:

D39J02GEN   

**20F934L**   

2984CPL   

29048L20GEN   

**1120934L**   

I only want the ones in bold to be detected. So where they end in L, only if they have a number before the L.

Edit: this one gets close:

`SELECT * FROM `table ` WHERE `part` REGEXP '^[0-9].*L';`

but still shows ones where there is anything after the L. This is also no closer to removing the letter L.