View Full Version : MySQL query
November 19th, 2000, 20:55
i need info on other querying functions (ex LIKE) and the syntax with using each.
November 20th, 2000, 20:01
SELECT * FROM table WHERE name like 'b%'
This will echo all results where the field called name that begins with the letter b.
November 22nd, 2000, 00:15
if you want to limit the amount of results then add LIMIT 0,20 to the end.. this limits it to 20 results
November 22nd, 2000, 05:18
I think the best you can do is get a book about SQL and read it there, it'll be more helpfull to you.
Teach Yourself SQL in 24 Hours
by Stephens and Plew.
Published by sams.
Altho it's not mySQL specific, you'll find it very helpfull.
November 30th, 2000, 17:17
You did look at http://www.mysql.com/documentation/mysql/commented didn't U?
Powered by vBulletin® Version 4.1.7 Copyright © 2013 vBulletin Solutions, Inc. All rights reserved.