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
&g
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
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 possible in any way?
At 15:36 2002-11-10 -0800, you wrote:
>>From: "A. J. Maclean" <[EMAIL PROTECTED]>
>>
>>I have a query like this:
>>
>>SELECT * FROM bc_posts WHERE MATCH (post_city, post_location, post_details,
>>post_message) AGAINST ('webster');
>>
>>I get the results as follows:
>>
>>webster hall
>>webster
>>web
From: Jan Steinman [mailto:Jan@;Bytesmiths.com]
Sent: Sunday, November 10, 2002 6:37 PM
To: [EMAIL PROTECTED]
Subject: Re: one word fulltext matching problem...
Without ORDER BY clause, results of a SELECT are in arbitrary order. That's
just the way SQL works -- there is no "relevan
>From: "A. J. Maclean" <[EMAIL PROTECTED]>
>
>I have a query like this:
>
>SELECT * FROM bc_posts WHERE MATCH (post_city, post_location, post_details,
>post_message) AGAINST ('webster');
>
>I get the results as follows:
>
>webster hall
>webster
>webster hall club
>
>How come the exact match (i.e. "
PROTECTED]>
Sent: Sunday, November 10, 2002 1:16 PM
Subject: one word fulltext matching problem...
I have a query like this:
SELECT * FROM bc_posts WHERE MATCH (post_city, post_location, post_details,
post_message) AGAINST ('webster');
I get the results as follows:
webster hall
w
I have a query like this:
SELECT * FROM bc_posts WHERE MATCH (post_city, post_location, post_details,
post_message) AGAINST ('webster');
I get the results as follows:
webster hall
webster
webster hall club
How come the exact match (i.e. "webster") does not get a higher relevance?
I remember se
January 29, 2002 1:15 PM
To: [EMAIL PROTECTED]
Subject: Pattern Matching Problem
Hello,
I have a big problem! I need to match all patterns in schdays from a
variable schdays and if schdays = mwf it only turns up mwf and not all
entries containing M, W or F. Is there a way to do this?
mysql> sel
CTED]]
Sent: Tuesday, January 29, 2002 3:46 PM
To: Douglas Brantz; [EMAIL PROTECTED]
Subject: RE: Pattern Matching Problem
SELECT schdays FROM courses WHERE (schdays LIKE "M") OR (schdays LIKE
"W") OR (schdays LIKE "F")
Matthew Walker
Ecommerce Project Manager
Mountain
2 1:15 PM
To: [EMAIL PROTECTED]
Subject: Pattern Matching Problem
Hello,
I have a big problem! I need to match all patterns in schdays from a
variable schdays and if schdays = mwf it only turns up mwf and not all
entries containing M, W or F. Is there a way to do this?
mysql> select schday
At 15:15 -0500 1/29/02, Douglas Brantz wrote:
>Hello,
>
>I have a big problem! I need to match all patterns in schdays from a
>variable schdays and if schdays = mwf it only turns up mwf and not all
>entries containing M, W or F. Is there a way to do this?
Yes, but you can't do it with LIKE excep
At 03:15 PM 1/29/2002 -0500, Douglas Brantz wrote:
>Hello,
>
>I have a big problem! I need to match all patterns in schdays from a
>variable schdays and if schdays = mwf it only turns up mwf and not all
>entries containing M, W or F. Is there a way to do this?
>
>mysql> select schdays from course
Hello,
I have a big problem! I need to match all patterns in schdays from a
variable schdays and if schdays = mwf it only turns up mwf and not all
entries containing M, W or F. Is there a way to do this?
mysql> select schdays from courses where schdays LIKE "%MWF%";
+-+
| schdays |
+-
PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Saturday, January 12, 2002 4:16 PM
Subject: Re: help please, patter matching problem
> No closing quotes in prepare.
>
> Also, I've never seen code that's looks quite like that; this may be
> cleaner:
>
> $sth=$dbh->pre
ROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday, January 12, 2002 9:49 AM
Subject: help please, patter matching problem
> mysql and Perl
>
> Can someone tell me what's wrong with this code:
>
> $sth=$dbh->prepare("SELECT Contacts FROM Info WHERE Name=?);
>
> $s
* Dan
> Can someone tell me what's wrong with this code:
>
> $sth=$dbh->prepare("SELECT Contacts FROM Info WHERE Name=?);
>
> $sth->execute("%$sname%");
You should use the LIKE operator:
Name LIKE "%roger%"
http://www.mysql.com/doc/S/t/String_comparison_functions.html >
--
Roger
--
mysql and Perl
Can someone tell me what's wrong with this code:
$sth=$dbh->prepare("SELECT Contacts FROM Info WHERE Name=?);
$sth->execute("%$sname%");
$dname = $sth->fetchrow_array;
$names is supposed to be a substring. So if I want to search for a middle
name or just a first name or even a
24 matches
Mail list logo
