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
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 [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent
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
think you can simplify the command to:)
rpm -Uvh --oldpackage filename
(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=STf=8t=434
- Original Message -
From: David Rayroud [EMAIL PROTECTED
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?
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
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 PROTECTED]; [EMAIL PROTECTED]
Sent: Tuesday, February 19
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 PROTECTED]; [EMAIL PROTECTED]
Sent: Tuesday, February 19, 2002
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