Clear parts of a field after / sign

[karsttuinstra]

Hello,
I hope somebody can help me with this. I have a collumn in a database which contains titles. The problem is that it contains the dutch title and then the english title devided by a '/' sign. Like this:
"hallo / hello"
I only want it to display the dutch title when i run a query on my website. So i want to delete the part after (and including) the '/' from my database.
Is there a way to do this with some php or something? I am not that good with php, so if someone could give me the exact code it would be awsome.

Thanx

[mwasif]

This query will display the dutch title only (remove the portion after first occurence of /). This query does not change any thing in database.

SELECT SUBSTRING_INDEX(title, '/', 1) AS dutch_title FROM table_name

If you want to change the title in database permanently, then run a UPDATE query

UPDATE table_name SET 
title = SELECT SUBSTRING_INDEX(title, '/', 1)

If you plan to update this in database, take backup of table.