substring

[sandy1028]

There is field called "text" and it is concatenated with the delimiter '##'.

 

How to select all the values before the delimiter '##'

 

And

 

How to select all the values after the delimiter '##'

[Amtran]

<?php
$query = "SELECT * FROM some_database";
$result = mysql_query($query);

while ($row = mysql_fetch_array($result)
{
$resultArray1 = explode('##', $row['somerow']);
$resultArray2 = explode('##', $row['somerow']);
}

[trq]

before

SELECT SUBSTRING_INDEX(`text`, '##', 1);

 

after

SELECT SUBSTRING_INDEX(`text`, '##', -1);