RDB--
You should try...
SELECT * FROM table WHERE INSTR(field1, '999997') > 0
[selects everything from 'table' where field1 has that job number within it]
Or, if you just wanted to run a query that would update every entry to not
include that "Job ID =" you could...
UPDATE table field1=SUBSTRING(field1, 10)
[modifies every field1 in 'table' to everything in field1 from the tenth
character until the end]
Hope this helps. Let me know if you need anything else. :)
- Will
----- Original Message -----
From: "Randall Barber" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, April 11, 2001 4:43 PM
Subject: [PHP-DB] Only part of a field SQL
Our Xerox production printers export a log in ':' delimited format.
No big deal, except that each field has a tag like so:
Job ID = 999999
Job ID = 999998
Job ID = 999997
See what I mean?
I have simply imported the whole CSV file into Access and was now wondering
if I could do the following?
Pull everything out of the field AFTER the '=' sign.
SELECT FIELD1, FIELD3, FIELD10 FROM ImportTable WHERE FIELD1=' everything
after the = sign ' AND FIELD3=' same idea ' AND FIELD10=' same idea '
So when I execute the query all I get for Job IDs is:
999999
999998
999997
Is there a way to do this in the query? I am totally inexperienced.
Thanks in advance,
RDB
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]