how to split a data from database based on character

Question

Hi I have a data april/2010 to jan/2011 Is there any way to split the data with character to and select the date as The value before "to" as FROM and The Value after "to" as TO how to selet the splited value......... while i am selecting the data as it is as select date from mytbl how to select the date as two values

Answer 1

If you have your data in a string, like this :

$str = 'april/2010 to jan/2011';

You can use the explode function to get the two parts :

list ($from, $to) = explode(' to ', $str);

Then, just to be sure, if we echo them :

echo "From : $from<br />";
echo "To : $to<br />";

We get :

From : april/2010
To : jan/2011