Jump to content


Photo

MySQL query question


  • Please log in to reply
1 reply to this topic

#1 Buyocat

Buyocat
  • Members
  • PipPipPip
  • Advanced Member
  • 267 posts

Posted 05 June 2006 - 07:26 PM

Can anyone give me a hand constructing a MySQL statement that would do something like this:
A. check that column 1 doesn't contain string S
B. check that column 2 doesn't contain string S1
THEN
C. insert into table a row with various information

I understand the syntax behind each of these queries individually, I am just curious whether I can do this all at once instead of each one separately (it would be nice to save the code/time); if it isn't clear I'm trying to screen duplicate values.

Thanks in advance, Buyo.
Looking for some easy-to-use tools?  Try these, https://sourceforge....jects/utils-php -- I made them myself.  They're distinct tools which are easy to understand and use.  See some examples uses at http://www.anotherearlymorning.com

#2 Buyocat

Buyocat
  • Members
  • PipPipPip
  • Advanced Member
  • 267 posts

Posted 05 June 2006 - 09:42 PM

*bump* sorry
Looking for some easy-to-use tools?  Try these, https://sourceforge....jects/utils-php -- I made them myself.  They're distinct tools which are easy to understand and use.  See some examples uses at http://www.anotherearlymorning.com




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users