Posted by Manchild on 09/03/05 06:31
atlantic wrote:
> I'm trying to build a form where the user searches for a name, and then all
> of the names that match are listed. I'd like both of these to appear on the
> same page.
>
> e.g. -
> +-----------------+
> Name: | Jimm | <Go>
> +-----------------+
>
> Would produce:
>
> Jimmy Johnson
> Jimmie Smith
> Jimmbo White
>
> Thanks for any input...
>
>
You need to learn your wildcards :D
http://www.tizag.com/mysqlTutorial/mysqlwhere.php
select name from yourtableofnames where name like 'Jimm%'
James
[Back to original message]
|