Tag : SUBSTRING_INDEX()

ItSolutionStuff.com have tutorials for SUBSTRING_INDEX() tag, here you can study articles of SUBSTRING_INDEX() tag, SUBSTRING_INDEX() tag posts collection, most popular and useful tutorials of SUBSTRING_INDEX() tag, here you can find list of all relevant posts and example about SUBSTRING_INDEX() tag, we have lists of tutorials and examples about SUBSTRING_INDEX() tag. very simple and quick example collection of Latest SUBSTRING_INDEX() tag.



How to get filename from file path in MySQL?

Sometimes we require to get filenames from path of table column in MySQL. If you are working on PHP then you can simply use basename() pre-define function of code PHP, But in MySQL you can't use basename() in select query. This mysql function you can use in code PHP, PHP framework like laravel, codeigniter etc. However, you can get simply filename or image name from path using SUBSTRING_INDEX() of MySQL. You can extract filename from path using substring_index(), substring_index() take three argument, first for column name, second for split string chat, and third get last element from split. .....

By Hardik Savani | November 30, 2016 | | 6088 Viewer | Category : PHP MySql
READ MORE

    Laravel - How to generate RSS Feed using roumen/feed package?

    Laravel - How to generate RSS Feed using roumen/feed package?

    Open Post

    Jquery - Display a loading gif image before a image loads using Eager ImageLoader plugin

    Jquery - Display a loading gif image before a image loads using Eager ImageLoader plugin

    Open Post

    How to create authentication(login and registration) in Laravel 5.2?

    How to create authentication(login and registration) in Laravel 5.2?

    Open Post

    Laravel 5 - category treeview hierarchical structure example with demo

    Laravel 5 - category treeview hierarchical structure example with demo

    Open Post

    Laravel 5 - Create Dummy Data using tinker factory

    Laravel 5 - Create Dummy Data using tinker factory

    Open Post

    Codeigniter 3 - Basic CRUD application with MySQL Example with Demo

    Codeigniter 3 - Basic CRUD application with MySQL Example with Demo

    Open Post