[thelist] SQL question

rudy r937 at interlog.com
Wed Jan 22 14:46:00 CST 2003

> > also, your variable $searchname contains the appropriate wildcards,
> > right?
> Yes, it will be a first or last name of a man or a woman.

okay, but if $searchname does not contain the appropriate wildcard
characters for your database, you might as well use an equality test for an
exact match instead of LIKE

e.g.  LIKE 'John%' will find both 'John' and 'Johnny'

what i meant was, presumably you are appending the wildcards to whatever the
user entered, before substituting the value of $searchname into the sql

> Do I need to use DISTINCT in case I have 2 men whose first name is George?



More information about the thelist mailing list