free
This is our archive, please go to the main forum page for the latest discussions and news about free web hosting.


MySQL query

razor
November 19th, 2000, 20:55
i need info on other querying functions (ex LIKE) and the syntax with using each.

BillWill
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.

john
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

jvv
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.
I recommend:

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.

perlboy
November 30th, 2000, 17:17
You did look at http://www.mysql.com/documentation/mysql/commented didn't U?





  
  News · Search free hosts · Free file hosting · Free image hosting · Reviews · Forums · Related Links · Advertising Info · Contact Us


Copyright © 1996-2008 Per Olof Sandholm. All rights reserved. Privacy Statement

EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum