Sql

Search

mysql string split to array

SELECT SUBSTRING_INDEX(
  SUBSTRING_INDEX('foo#bar#baz#qux', '#', 2), '#', -1
);

+----------------------------------------------------------------------+
| SUBSTRING_INDEX(SUBSTRING_INDEX('foo#bar#baz#qux', '#', 2), '#', -1) |
+----------------------------------------------------------------------+
| bar                                                                  |
+----------------------------------------------------------------------+

Comment

PREVIOUS	NEXT

Code Example
Sql :: mysql search multiple tables
Sql :: sqlite clear shell
Sql :: SQL Syntax of INNER JOIN
Sql :: sql table alias join
Sql :: postgresql having
Sql :: oracle ora-00054 how to unlock
Sql :: change sql global mode
Sql :: sql trying to delete database in use
Sql :: sqlyog clear cache query
Sql :: disable module odoo
Sql :: how to rename column name in sql server using query
Sql :: group by sql not ordering issues
Sql :: logical operators in sql
Sql :: sqlite löschen einer tabelle
Sql :: sql delete just one row
Sql :: getting customers with no orders sql
Sql :: create atable copy in pgsql
Sql :: postgres meta command to show all rows in table
Sql :: how to avoid duplicate records in sqlite
Sql :: how to completely uninstall sql server
Sql :: postgresql alter column data type from integer to integer array
Sql :: window function sql
Sql :: redirection 301 htaccess nom de domaine
Sql :: grab part of a string sql
Sql :: drop unique
Sql :: hour differeence in mysql
Sql :: disable database droping sql
Sql :: how to print some string in mysql
Sql :: how to find 2nd highest salary in mysql
Sql :: xampp mysql problem detected port 3306 in use by

Search

SQL

mysql string split to array

ADD CONTENT