Hi
i request a small help for know if it's possible.
Anyone know if they have a Sql request for
search the best value at one information:
Sample:
i have a table with:
ID int 5
Chaine int 16
and this entry:
1 12345
2 123
3 12
i am search a request in "WHERE" :
Chaine LIKE '12345
MAFHH (Masoomeen) Cable Network
Website: http://www.mcn786.net
Allah only desires to keep away the uncleanness from you, O people of the
House! and to purify you a (thorough) purifying.{33:33}
Respected Brothers & Sisters,
Assalam-o-Alaikum Wa Rahmatullahi Wa Baraka
Hi,
Well this question may seem funny, but I really need to know!
The problem is with counting a user's contribution in my site. Suppose that
each user that send an email will be stored in DB. Now I want to count
number of times that a user has sent an email.
I can simply use this :
SELECT id FRO
I hate when my dumbness shows on world-wide tv
Please nullify my last query= Subject: "not regexp"
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the lis
Would someone explain what is going wrong here.
obviously I'm not understanding something.
If the next query searches for patterns at the beginning of the string in a
column
mysql> select count(*) from a where addy1 not regexp
'^(apt)|^(rm)|^(room)|^(ste)|^(suite)|^(fl)|^(floor)';
+--+
| c
- Original Message -
From: "Jeremy Zawodny" <[EMAIL PROTECTED]>
To: "Network" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Wednesday, August 22, 2001 3:08 AM
Subject: Re: replace/insert into ... 150,000 -plus rows
>
> > I
Sorry for the duplicate msg. I forgot to state what version server I was
running (next line)
server version: 3.23.32
- Original Message -
From: "Network" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, August 20, 2001 11:38 PM
Subject: replace/insert into
The problem= The 'addy1' column or field (in attdata) is tainted with incorrect
data entries ... e.g. 'addy1' should only have addresses stored however, some
bright person(s) have managed to input company names in the address/addy1 field.
I'm presented the task of fixing this data before incorpora
Here's the code we have:
Set objConn = Server.CreateObject("ADODB.Connection")
objconn.Mode = adModeReadWrite
objConn.Open "dsn=myDSN"
...
vLastIndex = objConn.Execute("SELECT LAST_INSERT_ID()").Fields(0).Value
Here's what we got
Explorer just prompts:
Microsoft OLE DB Provider for ODBC D
Hi !
is there any way to do this ?
SELECT T2.monedaID, T2.fecha, T1.descripcion, T2.compra, T2.venta FROM UYMonedasBCU
T1, UYMonedasCotizaInter T2
WHERE
(T2.fecha = (SELECT DISTINCT MAX (T3.fecha )FROM
uymonedascotizainter T3 )) AND (T1.forma = 'Billete') AND (T2.monedaID = T1.id )
The matt
- Original Message -
From: <[EMAIL PROTECTED]>
To: "La Rocca Network" <[EMAIL PROTECTED]>
Sent: Wednesday, May 09, 2001 2:06 PM
Subject: Re: Re: ODBC for MySql with SSL
> Your message cannot be posted because it appears to be either spam or
> simply off to
MySQL 3.23 has full-text search built-in, and it's made for exactly this
situation. You'll need to create a index of type FULLTEXT:
http://www.mysql.com/doc/M/y/MySQL_full-text_search.html
Of course, the other way to do this is to create another table with the
keysword in it, and a pointer back
I'm porting some code from perl to php, and have experienced a tremedous
slowdown in one particular query, and I'm perplexed as to why. The query
is simply "Select * From my_table order by ID desc LIMIT 0,20", to get the
last 20 records that were entered. ID is the Primary Key, and it is
auto-i
$query="Select DISTINCT RECEIVER from TRANS_TBL order by TRANS_ID DESC LIMIT
10" ;
- Original Message -
From: "Randy Johnson" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday, March 10, 2001 10:41 AM
Subject: GETTING ROWS
> Here is a query:
>
>
> $query="Select RECEIVER from T
I've searched the MySQL manual and can't figure out how to convert one (or
all) tables to MyISAM. (I'm upgrading a very large database from 3.22 to
3.23).
I think there's a way to do it from the ALTER TABLE command, but I can't
seem to find any examples.
Thx,
Tac
---
I don't see an address for the list owner so I'm mailing this here in hope of
getting help. Why is the connection constantly resetting and not allowing me to
join the list?
This mail also serves as a test to see if I can post to the list without joining
via [EMAIL PROTECTED]
Mar 6 04:34:49 Im
16 matches
Mail list logo
