How to delete or get line in table only with some words?

[hunthunt]

Table data as follow:
keyword links
abc machine link1
great abc machine link2
abc machine link3
good abc machine link4
.....more data

I want to get random one link based on keywords.
For abc machine, I can get link1 or link3.

I find that delete lines can do some work, it has a range selection(containing text, not containing text). I select delete lines, not containing text, then input abc machine, it will delete nothing, because all keywords are contaning abc machine.

In microsoft access database I can do this job well, but not in zennoposter table.
SELECT Sheet1.keyword, Sheet1.link
FROM Sheet1
WHERE (((Sheet1.keyword)="abc machine"))
ORDER BY Rnd(id);

Has any other ways to do the same job?

 

[Nick]

Sure, you can implement a similar algorithm using graphics interface of Project maker or using C# code. In the second case, check out Wiki with examples on work with tables.