Worked like a charm! I couldn't find anything about this in MySQL docs
though... Neither before I knew what to search for nor after. What's up
with that?
Dean
- Original Message -
From: "Mike Hillyer" <[EMAIL PROTECTED]>
To: "Dean Householder" &l
Is it possible to run a query that will just alter text possibly using a regular
expression? I have about 250 rows that I want to strip quotes out of. Does anyone
know of an easy way to do this?
Dean
I am perplexed trying to retrieve all the rows I need in the query I'm
doing.
I have a table with keeping track of people using ID numbers as the primary
key and another table with coupon numbers and a reference to the first
table. But not all the second table is going to have correlating matches
t;
(I think you can simplify the command to:)
rpm -Uvh --oldpackage <>
(but I haven't tried it)
MySQL-Front now seems to work fine for me.
Hope this helps,
Dean Householder
http://mysqlfront.venturemedia.de/index.php?act=ST&f=8&t=434
- Original Message -
From: &qu
Okay, I thought I'd done this before but maybe not. I can't figure it out
now.
What I want to do is:
SELECT column AS something FROM table WHERE something > 5
Basically I'm creating a new column called something and I want to use it to
compare with in the WHERE condition. Is this possible?
U
Thank you all so much for helping me with this query. It works! Best of
all, now I understand how to join tables and such! Thanks again!
- Original Message -
From: "Rick Emery" <[EMAIL PROTECTED]>
To: "'Dean Householder'" <[EMAIL PROTECT
# 18 and such. I guess
I'm looking for a query that will match these to up either in the same row
or one after another.
Any help is SOOO appreciated!
Dean
- Original Message -
From: "Roger Karnouk" <[EMAIL PROTECTED]>
To: "Dean Householder" <[EMAIL PROT
I'm fairly new to MySQL, so if anyone could help me I'd really appreciate
it!
What I'm trying to do is join two pictures in a database to each other. My
database holds info about people with variables:
id, lname, fname, engagedto, pic
The engagedto field contains the id of the person they are
I want to run a query like:
select * from table order by rand() limit 3
in MySQL it would work but I need to run it in MSSQL. I've been searching
for a limit function in MSSQL and I can't find a way to do it. I'm
experienced with MySQL but know nothing about MSSQL. If someone could point
me i
