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

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

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

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.