|
-
Mar 23rd, 2008, 02:39 PM
#3
Fanatic Member
Re: Search Database and display the whole row
Actually dclamp, he wants to search for every record with the first name of john so drop off the LIMIT 1.
Also when you do pattern matching you use LIKE not =
http://dev.mysql.com/doc/refman/5.0/...-matching.html
So....
SELECT * FROM `family` WHERE FirstName LIKE '%john%'
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|