A little SELECT syntax

From: Dan (dan_at_danneh.demon.co.uk)
Date: 10/26/03

  • Next message: David N Murray: "Re: A little SELECT syntax" 
    To: dbi-users@perl.org
Date: Sun, 26 Oct 2003 11:22:47 -0000

    Hi,

    I've got a database that stores small messages for a service, what I want to
    be able to do is get all rows from the database where the columns "sent" and
    "readdate" match, I have this, but it's erroring. Any pointers please?

    SELECT * FROM memodata WHERE 1 AND to=1 AND readdate=sent ORDER BY id ASC

    Many thanks,

    Dan

    P.S: Using MySQL, DBD::mysql, not sure if you need to know that, but saying
    anyway ;)

  • Next message: David N Murray: "Re: A little SELECT syntax"

    Relevant Pages

    • Re: Need Advice on Linux vs. Windows for a Database-Driven Web Application
      ... We recently hired sales reps in several cities in the US ... > and Canada to maintain our displays in stores and to take orders from ... > in a database that we could access from the Head Office. ... No question - the Linux based one. ...
      (comp.programming)
    • Re: ISFDB unwell
      ... giving me a page saying "Cannot connect to the MySQL database", ... we may still have outstanding ...
      (rec.arts.sf.written)
    • Re: Max Exchage DB size in SBS
      ... private) rather than total. ... The stores grow as necessary to house their content, ... the database will grow by 100mb. ... becomes "slack" in the database. ...
      (microsoft.public.backoffice.smallbiz2000)
    • Re: setup
      ... > install the database. ... It keeps saying I don't have a ... Try one of the many support forums for MySql. ...
      (microsoft.public.security)
    • Re: Multi phase processing
      ... I writing a perl/mysql backend to a website, ... number of pages of input, then, at the end, stores all the info on the ... all of which is taken from some data tables on the database. ... approach completely and use a decent session module that lets you ...
      (comp.lang.perl.misc)