Re: MySQL sorting problem
| From: | Shane Wright | Date: | Tue, 06 Nov 2001 12:14:45 +0000 |
| Subject: | Re: MySQL sorting problem | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-73577@lists.php.net to get a copy of this message | ||
Hi
You really want to be splitting that into two fields - the S1 part and the 22
part (for S1.22). Then order by both fields.
This may also have other bonuses for getting subsets of information out (i.e.
all S1 skills...)
--
Shane
On Tuesday 06 November 2001 12:14 pm, De Necker Henri wrote:
> Hi there
>
> I have the following problem :
> My company has about a 1000 Skills that are associated to specific
> employee's listed as :
> S1.1
> S1.2 ....
> S1.21
> S1.22 ...
> S1.3
> S1.4
> S2.1
> S2.2 ....
>
> and so on.
> All these must be listed by me in a db.
> Now I have the problem a sorting them in a numeric way!
> If I sort them "assenting" , my result will be S1.1, S1.11, S1.12 S1.13,
> 1.2 and S1.3
> It must be S1.1, S1.2, S1.3, S1.11, S1.12 ex.
> I have tried S1_1, S1_2, S1_3 ex. this also doesnt work.
>
> Is there different way I can list them or safe the in the db.
> Any help will be appreciated
> Thank u!