mysql - How can i separate the data from selected data -

i have column in table name url , contains multiple value "https://www.google.com/#q=how+to+make+a+android+app" ,

http://www.bing.com/search?q=how+to+make+a+android+app&go=&qs=n&form=qblh&pq=how+to+make+a+android+app&sc=8-15&sp=-1&sk=

i want data separately in output

website = https://www.google.com

keyword = how make android app.

any idea plz, how can in mysql.

you can use substr() function in php cut string. in case, can characters end of 'https://www.google.com'.

read more @ http://ro1.php.net/substr

in case want directly in query, can use substr() well. sql syntax goes this:

select substr(column, start_position, desired_length) table_name

*select substr(column_name, 1, 20) table_name;*