PHP SQL - String problem

Author

String problem

ADB

2005-01-17, 8:56 am

Sorry, I shall repost as no answer yet for this boring problem :

Hi
I have some title, recorded as : "L'Ind=E9pendant"
I would like to transform it this way : "Ind=E9pendant (L')"

May I do it with phpmyadmin ? And what should be the syntax ?
Or what should be the syntax in php ?
Thanks in advance
ADB

--=20
Guide M=E9diterran=E9e :
http://guidemediterranee.free.fr ou http://guidemediterranee.info

Guide Manche:
http://guidemanche.free.fr ou http://guidemanche.info

Guide Atlantique:
http://guideatlantique.free.fr ou http://guideatlantique.info

Steve

2005-01-17, 3:57 pm

> I have some title, recorded as : "L'Ind=E9pendant"
> I would like to transform it this way : "Ind=E9pendant (L')"

Boring reply... for titles starting with "L'":

UPDATE mytable
SET title =3D CONCAT( RIGHT( title, LENGTH( title ) - 2 ), " (L')" )
WHERE LEFT( title, 2 ) =3D "L'"

---
Steve

ADB

2005-01-23, 8:57 pm

Thanks for help.
ADB

Steve a =E9crit :
>=20
>=20
>=20
> Boring reply... for titles starting with "L'":
>=20
> UPDATE mytable
> SET title =3D CONCAT( RIGHT( title, LENGTH( title ) - 2 ), " (L')" )
> WHERE LEFT( title, 2 ) =3D "L'"
>=20
> ---
> Steve
>=20

--=20
Guide M=E9diterran=E9e :
http://guidemediterranee.free.fr ou http://guidemediterranee.info

Guide Manche:
http://guidemanche.free.fr ou http://guidemanche.info

Guide Atlantique:
http://guideatlantique.free.fr ou http://guideatlantique.info

Sponsored Links