Hyperlink field help

I have created a table in MYSQL with a field containing the text of a web link. When I have finished working out how to code search and display pages will this link be "clickable" if the field is set as a VARCHAR field?

I suppose the question is should the field be set to a different type rather than VARCHAR to display as a hyperlink in results or is this irrelevant as its status will be dealt with on the webpage independently of the database field setting?

Sorry if its a daft question, all new to me.

Basically it is irrelevant as far as the field being clickable, that is handled when the page is built as you stated. What is relevant is what length the link text is. VARCHAR can have a max length of 255 in MySQL so if you might have links with a length greater than 255 characters, you might want to consider the TEXT type.

Thankyou for the fast response.

The links will be to pages hosted at my own site and definately less than 255, so I have at least one setting right then. ;)

Just need to learn queries tomorrow and get the pages done for searching and results, should be entertaining....tho my head hurts already!

To search and select records from the table you can simply use the SELECT statement and WHERE clause:

It sounds like you need to have a hyperlink to a website URL or a email link.

That piece of code looks to be exactly as I need, many thanks. The field will indeed be a hyperlink to a webpage.

The database is a simple list of contacts around the country connected with problem solving a product. It contains a few simple fields with the town and postcode fields searchable, the results will have contact details and a webpage link.

My brain is already in protest at designing a search and results page but that's where the fun in life is, at least thats what I keep telling my shrink !!