text index virker ikke
Hej,create table mmu(
ORG VARCHAR(300) NULL) engine=MyISAM DEFAULT charset=latine1;
Jeg fylder tablen med:
9096;534;345;345
90;43;234;24
9096;234;423;24234
2342;423;234;234
2434;423;243;423
....15000 raekker total
alter table mmu add fulltext (ORG)
Men faar igenting naar jeg prover folgende:
select * from mmu where (match (org) against (´9606;´)
select * from mmu where (match (org) against (´*9606;*´)
select * from mmu where (match (org) against (´9606´)
select * from mmu where (match (org) against (´*9606*´)
hvad gor jeg galt?
Mvh,
Rune