I've written doesn't seem quite right.
Because of the AND following the LIKE d condition, it seems like all
the records will have to have choice2 equaling 2.
Some help clarifying this issue would be appreciated. Thanks.
Bob Cohen
b.p.e.Creative
http://www.bpecreative.com
Design and production
Thanks to Bernard, Sunmaia, and Ingo! I knew the query wasn't quite
right.
Bob Cohen
b.p.e.Creative
http://www.bpecreative.com
Design and production services for the web
Put creative minds to work for you
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
| grep -i my*. That'll give you the exact
names of all the mysql rpms installed on your system.
Check out http://www.linuxhomenetworking.com/linux-hn/rpm.htm for a
great tutorial on using rpm.
Bob Cohen
b.p.e.Creative
http://www.bpecreative.com
Design and production services for the web
Put
/mysql/
So it would appear that the mysql daemon is running but now I can't
access the databases with the mysql client e.g., mysql -u root -p.
Help would be most graciously appreciated.
Bob Cohen
b.p.e.Creative
http://www.bpecreative.com
Design and production services for the web
Put creative
to field data.
Here's my stab at the SQL:
UPDATE 02093_xdir_links
SET title *
WHERE title REGEXP[]*[];
Will this work?. Is there a better way? Did I get it right? Normally
I'd just experiment but this is a live database.
Thanks in advance.
Bob Cohen
b.p.e.Creative
http://www.bpecreative.com
City
State Zip
1 Joe 1313 Mockingbird Lane TransylvaniaPA
02098
^^^
To my untrained eye it looks like the REPLACE, as you wrote it above,
searches the title field for anything e.g., *. And replaces it with
nothing .
Thanks.
Bob Cohen
designer not a programmer. I'm not at all sure how
to accomplish this task. Though I would like to learn.
Any help would be appreciated. Thanks.
Bob Cohen
b.p.e.Creative
http://www.bpecreative.com
Design and production services for the web
Put creative minds to work for you
--
MySQL General
know I must be missing
something basic. Help would be appreciated!
Bob Cohen
b.p.e.Creative
http://www.bpecreative.com
Design and production services for the web
Put creative minds to work for you
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http
I don't really know exactly what happened. As luck would have it, I had
a username with all privileges that WOULD connect. Using that, in
combination with shutting down and restarting MySQL, I reorganized the
user database and now things work. Thanks.
Bob Cohen
b.p.e.Creative
http