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 it that this is the data value stored in the field. What does the schema look like? > 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 is > not terribly useful.) What do you mean by "numeric order"? If there was another row containing: (72+18) Landscape Then it would likely appear before the row you mentioned - and not in a "numeric" sequence at all. Do you mean that you want the parentheses, the digits, the plus sign, AND the space character ignored for the purposes od the sequence, and thereafter that the values should be treated as alpha? Is there any possibility of numerics appearing after the first alpha character? Would that matter or would they have to be ignored as well? > So - is there a function or way I can sort this array alphabetically > rather than numerically? Yes there are various ways and means, right up to the 'expensive' regular expression function. I think we can solve this one quickly enough - given a good understanding so we don't end up chasing red herrings! Please post the query you are using currently, together with a few rows of output. Then highlight the problem by showing the sequence that you would prefer to see. Please advise, =dn --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
