I have created an extra column in Links SQL to record UK postcodes against a link.
What I would like to do is to search this column using the 'similar words' approach, as in the Advanced Search option.
For example, if my new column contained:
ST5 1QY
ST9 2FY
ST9 4JK
SH1 3GH
and I entered ST in the search box, it would identify the first two codes, ST9 the middle two etc.
I have tried using the existing advanced search option to achieve this, but it does not appear to identify my new column (I am aware of the three character restriction which has been discussed on another thread).
Do I need to alter search.cgi to pick up my new column? I'd assumed it would do so automatically, as I did add the column though the admin panel.
Any advice would be much appreciated (Links SQL newbie!!). I hope the above is clear - if not, let me know!
Thanks
What I would like to do is to search this column using the 'similar words' approach, as in the Advanced Search option.
For example, if my new column contained:
ST5 1QY
ST9 2FY
ST9 4JK
SH1 3GH
and I entered ST in the search box, it would identify the first two codes, ST9 the middle two etc.
I have tried using the existing advanced search option to achieve this, but it does not appear to identify my new column (I am aware of the three character restriction which has been discussed on another thread).
Do I need to alter search.cgi to pick up my new column? I'd assumed it would do so automatically, as I did add the column though the admin panel.
Any advice would be much appreciated (Links SQL newbie!!). I hope the above is clear - if not, let me know!
Thanks