Hi,
I have looked at the online documentation and the mysql books that I
have but can find no answer. I have a field that looks like this:
(8+2) Landscape
I want to sort on the alphabetic characters. My mysql query does an
order by this field and that returns a numeric order (which for me
Hi Nicole,
Perhaps it's me, but I'm having trouble following you - as I did with the question
I've just finished responding
to...
I have looked at the online documentation and the mysql books that I
have but can find no answer. I have a field that looks like this:
(8+2) Landscape
I take
Sorry Dan, I had actually replied to Steve who had asked the same
question but I forgot to reply to the list with this:
here is the query:
select catval,catdescr from embiteccat
where catzid=$zid and catlid=$lid and catunder=$cat order by
catdescr;
Here is a some data:
Nicole,
RTFM: 6.3 Functions for Use in SELECT and WHERE Clauses
in particular the String Functions
If the first space (in every row) can be taken as the 'marker' of what to remove
(including the space itself),
then take a look at the following:
SELECT catval, RIGHT( strcatdescr, POSITION(