OT but related: DNS using SQL databases

2002-10-03 Thread David Durham 

Hi,

I have heard of some Linux based DNS services that use MySQL as the bases 
for zone files. Is there anyone who could point me in the right direction 
or has experience in using these tools. The is my understanding that 
queries can be created that allow much easier maintanence of the DNS system.

Thanks.

-David



-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Searching MySQL fields in PHP forms

2002-09-17 Thread David Durham 

help with Searching MySQL fields in PHP forms.

We have a couple of search pages on our site and I would like to know what 
wild card characters can be used, for example % before or after a keyword. 
If there is a list could someone please point me in the right direction.

Thanks.

-David





-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

SQL Syntax

2002-08-25 Thread David Durham 

This may be a truly dumb question, but could someone please tell me why 
this sql query/ statement does not work:

update CompanyContacts
set ByEmailAddress = '[EMAIL PROTECTED]'
where Description like '%marve%'

If I say:
select * from CompanyContacts
where Description like '%marve%'

I get the correct response.

Thanks in anticipation.

-David 


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

SQL Syntax (May be OT)

2002-07-25 Thread David Durham 

If this question is off topic, please let me know.

I have a description field with a set of keywords. I need to update some 
data based on a keyword, which is  randomly placed in the field. Can 
someone please help with a SQL syntax to find the word within the field.

Thanks in anticipation.

-David


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php