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 input box in the form. Thanks.
Jamie Saunders
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 input
://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: [EMAIL PROTECTED]
Subject: Re: [PHP] searching a MySQL database
On Sun, 6 May 2001
Can anyone tell me what I would use to query a MySQL database in a search?
If the search field, was for example, a variable like "town", would the
results page use something like this? :
$sql = " SELECT * FROM table_name
WHERE towns = \"$town\" ";
I remember seeing someone post
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%'
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
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 is a character that
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 General
8 matches
Mail list logo
