Friday 10 February 2023

How to get filename from file path in MySQL?

 

How to get filename from file path in MySQL?

 


SELECT id
, name, SUBSTRING_INDEX(filepath, '/', -1) FROM `categories`

No comments:

Post a Comment

Note: only a member of this blog may post a comment.

Blog Archive