Marcus Bointon wrote:
On 9 May 2006, at 14:27, Wolfram Kraus wrote:
WHERE concated_field LIKE '%87682%'
No, because that would also match numbers that contain that sequence
like '18768232876825'.
WHERE concated_field LIKE '87682<%' OR concated_field LIKE '%>87682'
Still poor performanc
Marcus Bointon schrieb:
On 9 May 2006, at 14:27, Wolfram Kraus wrote:
WHERE concated_field LIKE '%87682%'
No, because that would also match numbers that contain that sequence
like '18768232876825'.
2. This doesn't sound like a good DB-Design, why don't you use two
seperated fields for bo
On 9 May 2006, at 14:27, Wolfram Kraus wrote:
WHERE concated_field LIKE '%87682%'
No, because that would also match numbers that contain that sequence
like '18768232876825'.
2. This doesn't sound like a good DB-Design, why don't you use two
seperated fields for both numbers, or a m:n ta
彭一凡 schrieb:
> try this:
> WHERE concated_field LIKE '87682%'
> or
> WHERE concated_field LIKE '87682_'
>
would give me 876825 what i am not looking for.
And i were also looking for 87682.
So this doesn't work.
But thanks anyway :)
--
Smileys rule (cX.x)C --o(^_^o)
Dance for me! ^(^_^)o (o
Wolfram Kraus schrieb:
Barry wrote:
Hello everyone!
I have a slight problem matching rows.
My problem is the Value in a textfield is: "8768239857"
I created that with concat.
Is there a way to match one specific number out of that field?
like WHERE SUPERFUNCTION(concated_field) = 87682
WHER
try this:
WHERE concated_field LIKE '87682%'
or
WHERE concated_field LIKE '87682_'
it is based on SQL-99, not using PHP
- Original Message -
From: "Barry" <[EMAIL PROTECTED]>
To:
Sent: Tuesday, May 09, 2006 8:49 PM
Subject: Matching problem
> Hello everyone!
>
> I have a slight
Barry wrote:
Hello everyone!
I have a slight problem matching rows.
My problem is the Value in a textfield is: "8768239857"
I created that with concat.
Is there a way to match one specific number out of that field?
like WHERE SUPERFUNCTION(concated_field) = 87682
WHERE concated_field LIKE '%
Barry schrieb:
Hello everyone!
I have a slight problem matching rows.
My problem is the Value in a textfield is: "8768239857"
I created that with concat.
Is there a way to match one specific number out of that field?
like WHERE SUPERFUNCTION(concated_field) = 87682
Is something like that poss
