I have a table with a field defined as a varstrlst
I am able use likep to match the whole field or part of the field starting from the beginning. However I am having difficulty in my SQL statement being able to use likep to pick uo any of the sub_items in the list.
If I have a variable with an item name $myitem, I am using a where statement in my SQL to limit the search on the item field as follows:
sql etc etc etc...
where item likep $myitem
What I am looking for is a simple strategy that can be used in the SQL statement that would treat the whole varstrlst like a string and allow me to use a Metamorph Inverted index like I would use in a string.
Thanks
I am able use likep to match the whole field or part of the field starting from the beginning. However I am having difficulty in my SQL statement being able to use likep to pick uo any of the sub_items in the list.
If I have a variable with an item name $myitem, I am using a where statement in my SQL to limit the search on the item field as follows:
sql etc etc etc...
where item likep $myitem
What I am looking for is a simple strategy that can be used in the SQL statement that would treat the whole varstrlst like a string and allow me to use a Metamorph Inverted index like I would use in a string.
Thanks