Web Hosting Talk







View Full Version : how to you retrieve data from data in SET in a mysql row?


matt2kjones
11-07-2002, 08:53 AM
Hi, i have never used set's before, and dont quite understand how the data is retrived from a set.

I know how to retrive data from normal fields.


could someone give me info. i have looked through a few books, but nothing.

Thanx so much

Matthew Jones

Studio64
11-07-2002, 08:57 AM
Can you explain what you mean by 'sets'?

Standard MySQL retrieves go along the lines of

SELECT (feild names) FROM (table name) WHERE (condition)

e.g. SELECT ID, Name, Address FROM Customers WHERE Name='Bob'

matt2kjones
11-07-2002, 12:29 PM
SET, its a type of field, like TEXT, or VARCHAR

dont matter