[phpXperts] About Searching slashes

How do I search for a column that contains back slashes? This will
not work
select *
from orders
where orderval like '%\\%'

How can I write a sql statement that will replace all shashes with
nothing, actually, to be safe, \' with nothing, and multiple shashes
with nothing too.

so the following examples will have the same result
test\'s
test\s
test\\\\\s
test\\\\\'s

will all be:
tests

------------------------------------

Visit phpXperts website at www.phpxperts.netYahoo! Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/phpexperts/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/phpexperts/join
(Yahoo! ID required)

<*> To change settings via email:
mailto:phpexperts-digest@yahoogroups.com
mailto:phpexperts-fullfeatured@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
phpexperts-unsubscribe@yahoogroups.com

<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/