how to split a data from database based on character

Question

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

Please show full, complete examples of what the fields look like, and the desired results. Otherwise, it's impossible to suggest correct splitting or regex code. — Pekka
– Pekka, Commented Apr 3, 2010 at 10:52

Pascal MARTIN · Accepted Answer · 2010-04-03 11:12:18Z

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

answered Apr 3, 2010 at 11:12

Pascal MARTIN

402k82 gold badges665 silver badges666 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

udaya Over a year ago

@pascal Martin Thanks for your effort ....But This is like getting the result and then spliting data i am looking for a method which splits the data in the query itself like < select date as from,date as To

Collectives™ on Stack Overflow

how to split a data from database based on character

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related