I have a query that is admittedly inefficient in that it is doing
multiple OR clauses and joining multiple tables. However, the query
runs at an acceptable speed if I am in a terminal session and run the
query directly in the terminal. On the other hand, when PHP performs
the same query for use
+--------+----+
Any help would be greatly appreciated!
Thanks.
Chris Fowler
[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
++
| 1 | TV/VCR | Event One |
| 2 | Overhead Projector | Event Two |
| 3 | Table and Chairs | NULL |
| 4 | Artboard | NULL |
+++----+
Any help would be greatly apprecia
tables would be dropped. For
this example, the individual table would have a field added called
individual.street.
The problem:
How can a write a statement in MySQL 4.0.12 that will move
address.street data into individual.street?
Thanks!
Chris Fowler
--
MySQL General Mailing List
For list
sales_opp_source.id =
sales_opp. sales_opp_source_id INNER JOIN contract ON sales_opp.id =
contract. sales_opp_id GROUP BY name;
Thanks.
Chris Fowler
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
cords:
(555) 123-1234
123-4567 x16
I want a SQL statement that will return the 2 records like this:
5551231234
123456716
This is not proper syntax, but I would think it is close...
select replace(contact_phone, REGEXP "^[1234567890]",'') from
individual;
I would really appreciate an
cords:
(555) 123-1234
123-4567 x16
I want a SQL statement that will return the 2 records like this:
5551231234
123456716
This is not proper syntax, but I would think it is close...
select replace(contact_phone, REGEXP "^[1234567890]",'') from
individual;
I would really appreciate an
st |1 | name_last | A
|1060 |5 | NULL | |
++++--+-
+---+-+--+----+-+
Regards,
Chris Fowler
-