underscore ignored?
Hi,
I am using keyword tags to select videos from a database using a WHERE clause of tag_field LIKE '%get_var%', and the get_var contains underscores. The keywords in the tag_field are separated by spaces not underscores but I am getting the right records returned.
For example SELECT * FROM table WHERE tag_field LIKE '%hot_pepper%' returns all records where the tag_field contains 'hot pepper'.
What's up with that?
TIA,
Brant
Edited 1 time(s). Last edit at 03/12/2008 01:12PM by Brant Ruskin.
Subject
Views
Written By
Posted
underscore ignored?
5631
March 12, 2008 01:09PM
2443
March 12, 2008 01:23PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.