In article <[EMAIL PROTECTED]>,
"Jason Glicken" <[EMAIL PROTECTED]> writes:
> I have 2 tables set up in MySQL, one with a dialed number field and
> duration, the other with a list of country codes, there names, and the
> rates. I am trying to match the dialed number with country code. My
> probl
I take it this is the back end for a web application of some kind.
removing the dashes before the insert with the procedural language
should be trivial. What language is on the front end of this?
Creating a regular expression which would match dashed or non-dashed
number would not be that hard
Whoops. I was thinking about how I have my isbn table stored. ;) I
prefer to remove all formatting from numbers like this(isbn, phone
numbers, social security numbers, etc) before storing them. Anyway,
here's something that should work. I'm not sure if it is the most
efficient way to do thi
Hi Bob,
I think this might be in the wrong direction - my isbn is saved with the
dashes, so I would need it to look like:
select * from test where REPLACE('myvalue','-','') = '12';
which I'm not sure will work. When I get on my machine I'll give some
variations of this a try, thanks for the qui
Oh, I think I know this one.
Copied from my console:
mysql> select * from test;
++-+
| id | myvalue |
++-+
| 1 | 12 |
| 2 | 15 |
| 3 | 3 |
| 4 | 10 |
| 5 | 10 |
| 6 | 10 |
++-+
6 rows in set (0.04 sec)
mysql> select * from tes
At 17:02 + 3/24/02, julian haffegee wrote:
>Hi all,
>
>I currently have
>
>$result = mysql_query ("SELECT title_id, title FROM documents_tbl, url_tbl
>WHERE (documents_tbl.title_id = url_tbl.url_id) AND keywords LIKE '%$temp%'
>AND title_id != '$myrow[title_id]'");
>
>this works to an extent,
ssion matching on each row? You could add two more columns, days_mwf
and days_th, to speed up the common queries.
Bret
-Original Message-
From: Matthew Walker [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 29, 2002 3:46 PM
To: Douglas Brantz; [EMAIL PROTECTED]
Subject: RE: Pattern Mat
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
SELECT schdays FROM courses WHERE (schdays LIKE "M") OR (schdays LIKE
"W") OR (schdays LIKE "F")
Matthew Walker
Ecommerce Project Manager
Mountain Top Herbs
-Original Message-
From: Douglas Brantz [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 29, 2002 1:15 PM
To: [EMAIL PROTECTED]
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
Then yes, it should be returned.
> -Original Message-
>
> On Sun, Aug 12, 2001 at 11:43:31PM -0700, Joe Sheble (Wizaerd) wrote:
> > an example would be:
> >
> > this is some text that would fall within the text field (somefield):
> >
> > "if you want to see some nice images, check out
On Sun, Aug 12, 2001 at 11:43:31PM -0700, Joe Sheble (Wizaerd) wrote:
> an example would be:
>
> this is some text that would fall within the text field (somefield):
>
> "if you want to see some nice images, check out href="http://www.photoshopuser.com>this website"
>
> and the query would be:
an example would be:
this is some text that would fall within the text field (somefield):
"if you want to see some nice images, check out http://www.photoshopuser.com>this website"
and the query would be:
WHERE somefield like '%photoshop%'
the above record should not be returned.
> -Orig
On Sat, Aug 11, 2001 at 10:54:58PM -0700, Joe Sheble (Wizaerd) wrote:
>
> I have a text field that contains some plain text intermingled with
> html tags. In querying the database, if the keyword I'm searching
> for falls within the plain text, that record should be returned.
> However, if the ke
> (REGEXP).
>
> I have a text field that contains some plain text intermingled with html
> tags. In querying the database, if the keyword I'm searching for falls
> within the plain text, that record should be returned. However, if the
> keyword falls within an html tag, it should not be returned
16 matches
Mail list logo
