MySQL query

[nebu]

Hi,
I wanted to know how can I query a string such that it does not contain a slash at the end?

right now i was trying

select string_data from table_of_data where string_data not rlike "/$";

but this does not work!

what would the right form of the query be?

[jobix]

You might need to escape it, by using a "\", i.e., like this "\/$", otherwise it might be getting interpreted as something else. Haven't tested it, but speaking based on my experience with other scripts/languages.

[Some Penguin]

NOT LIKE '%/' should work. No need for ^, $ in LIKE syntax; they're implicit; and % is basically '.*'.