How to get the first record that meet my criteria??

Bassam72 · #1 (**permalink**) 03-15-04, 00:12

Hello Guys,
I have table called Gateway with three fields: Aliase_No, Gateway_IP and Gateway_MAC. I want to retrieve the first record that its Gateway_IP is 0.0.0.0, so anyone can tell me what is the SQL statement that should I write to get that record???

Thanks
Bassam72

reneeb · #2 (**permalink**) 03-15-04, 04:12

Code:

SELECT * FROM table WHERE Gateway_IP = '0.0.0.0' LIMIT 1

lslars31 · #3 (**permalink**) 03-15-04, 22:46

you dont need the LIMIT at the end just: SELECT * FROM $table WHERE Gateway_IP='0.0.0.0'

Well I guess you could add it for security reasons.

Internet Services

Web Development

Digital Marketing

Consumer Tech