strip <a href> in mysql
Posted: Mon Feb 28, 2005 10:02 am
Hi All,
i Have a query like this to order by w_location
select * from tbl_workshop where frn_cid = $frn_cid order by w_location asc
w_location is stored in the db as "<a href="mypage?wid=1">New York</a>"
The order by w_location in the query orders the list by "wid=1" as it is stored in the field, how can i order by lets say New York and strip the html when doing my query?
i Have a query like this to order by w_location
select * from tbl_workshop where frn_cid = $frn_cid order by w_location asc
w_location is stored in the db as "<a href="mypage?wid=1">New York</a>"
The order by w_location in the query orders the list by "wid=1" as it is stored in the field, how can i order by lets say New York and strip the html when doing my query?