Verschil tussen cijfers en letters?
Code (php)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
Query Output:
> SELECT * FROM filtertest
+ --------- + -------- +
| code | cat |
+ --------- + -------- +
| 000000 | 1 |
| 1x3456 | 1 |
| XY3333 | 1 |
| 0 | 1 |
| 0xxxxx | 1 |
| 0123456 | 1 |
| XY3333 | 1 |
| 0x | 1 |
+ --------- + -------- +
8 rows
Query Output:
> SELECT * FROM filtertest WHERE code
+ --------- + -------- +
| code | cat |
+ --------- + -------- +
| 1x3456 | 1 |
| 0123456 | 1 |
+ --------- + -------- +
2 rows
> SELECT * FROM filtertest
+ --------- + -------- +
| code | cat |
+ --------- + -------- +
| 000000 | 1 |
| 1x3456 | 1 |
| XY3333 | 1 |
| 0 | 1 |
| 0xxxxx | 1 |
| 0123456 | 1 |
| XY3333 | 1 |
| 0x | 1 |
+ --------- + -------- +
8 rows
Query Output:
> SELECT * FROM filtertest WHERE code
+ --------- + -------- +
| code | cat |
+ --------- + -------- +
| 1x3456 | 1 |
| 0123456 | 1 |
+ --------- + -------- +
2 rows
Zegt genoeg
Toevoeging op 09/07/2012 18:59:57:
Lol, ik heb Fiddle laten crashen, gheghe