MySQL Forums
Forum List  »  Quality Assurance

underscore ignored?
Posted by: Brant Ruskin
Date: March 12, 2008 01:09PM

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.

Options: ReplyQuote


Subject
Views
Written By
Posted
underscore ignored?
5185
March 12, 2008 01:09PM
2266
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.