uot;;
}
break;
}
[/CODE]
- John Vanderbeck
- Admin, GameDesign (http://gamedesign.incagold.com/)
- GameDesign, the industry source for game design and development issues
> -Original Message-
> From: bill [mailto:[EMAIL PROTECTED]]
> Sent: Sunday, May 06, 2001 11:10 AM
> To: [E
On Sun, 6 May 2001, Jamie Saunders wrote:
> Hi,
>
> I've set up a MySQL database and an HTML search form. I'd like to know how
> to search the database with whatever it entered into the form. It only
> needs to be a simple search, returning anything that matches the word(s)
> entered into the i
> Here are some queries of the above table with their results
> bases='Ft. Worth' returns record 1
> bases LIKE '%Worth%' returns record 1
> bases LIKE '%Ft.%' returns 1 & 2
> bases LIKE '%' returns all records (in this case, 1 & 2)
>
> See?
That makes perfect sense. Thank you!
--
PHP Ge
> > towns = '$town'
> > ...and...
> > towns LIKE '$town'
> >
> > ...are essentially the same without the % wildcard character. Thus,
> >
> > towns = '$town'
> > ...is much different than...
> > towns LIKE '%$town%'
>
> How different are they? I'm not even sure what a wildcard is?
A wildcard
> You've basically got it... the advantage of LIKE is that you can add
> wildcards to specify what can be different...
>
> towns = '$town'
> ...and...
> towns LIKE '$town'
>
> ...are essentially the same without the % wildcard character. Thus,
>
> towns = '$town'
> ...is much different than...
> t
You've basically got it... the advantage of LIKE is that you can add
wildcards to specify what can be different...
towns = '$town'
...and...
towns LIKE '$town'
...are essentially the same without the % wildcard character. Thus,
towns = '$town'
...is much different than...
towns LIKE '%$town%'
6 matches
Mail list logo
