i have a some data code like this :
- PR 00001J
- PR 00001B
- PR 00002B
- PR 00002J
- PR 00003J
how i can get data only J with where clause ? is it need something like regex ?
i've been try with this query but the output was
SELECT MAX(request_code) as max_request_code FROM `request` WHERE RIGHT('request_code',1) = 'J'
anyone can help me out ?